Lesley
January 9, 2024, 4:30pm
1
Is it possible to have a whole row formatted with a specific background colour based on a single field value for that record? I know I can do this column by column, but that requires setting up 7 conditional format rules for each of 7 columns, which is a bit of a pain!
Any suggestions gratefully received!
Hi @Lesley - I think this is what you’re after.
1 Like
Lesley
January 10, 2024, 9:13am
3
Fabulous, thank you! I found Davide Agnolazza’s original post for the actual Java script here
I found myself in the situation where I needed a table row to have a certain background color to be quickly identified. However, display rules are applied by cell, which means that you shoud set the same display rule for each column of the table. For very big tables this is a pain so I came out with this simple trick. Basically I am applying the display rule on the first column and then through javascript I am replicating the style in the rest of the columns of that row.
This is my code:
$(…
and it worked perfectly.
1 Like
Hi
It is definitely worth a look.
Craig
Lesley
January 11, 2024, 9:22am
5
ooh… lots of cool stuff in there! Many thanks
