Conditional Formatting of ROWS in a grid view

[Lesley]

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!
TIA
LesleyB

[CarlHolmes]

Hi @Lesley - I think this is what you’re after.

Table Backgrounds - Knack Database

[Lesley]

Fabulous, thank you! I found Davide Agnolazza’s original post for the actual Java script here

Table row background based on first cell style

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.

[CSWinnall]

Hi
Take a a look at this no code approach

Keywords

It is definitely worth a look.

Craig

[Lesley]

ooh… lots of cool stuff in there! Many thanks