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!
@Lesley - I think this is what you’re after.
Fabulous, thank you! I found Davide Agnolazza’s original post for the actual Java script here
This is my code:
and it worked perfectly.
Take a a look at this no code approach
It is definitely worth a look.
ooh… lots of cool stuff in there! Many thanks