Hello all,
I need to create and use a sheet daily.
My question is how to colour an entire row's colour to my desired colour depending on one cell in the same row. Also I would like numbers to do it real time, so as I fill in the cells and I put my 'trigger' in a cell the row would change colour automatically.
is such thing possible to do?
Thank you!
Hi Mark,
We can't see your table, so I made a guess about the "trigger" (the value exceeds the target).
Make a copy of the table. When all works well, you can move (Cut and Paste) the copy to another Sheet (Tab).
Formula in A2 of 'Target Surpassed' (and fill right and fill down) =IF(Table 1::$B2>Table 1::$C2,Table 1::A2,"")
Now select all body cells in Table 1 and apply conditional Highlighting
That Highlighting rule will automatically adjust for each selected cell in Table 1.
Please call back with questions.
Regards,
Ian.
As you've probably discovered Conditional Formatting applies to a cell, not its entire row.
It's possible to achieve the "highlight an entire row" effect by supra-imposing (placing underneath) another table that provides the background color by comparing the values in its cells to the values in the cells in your original table. I find that fiddly so I don't do that but others here can demonstrate how.
It is possible to "highlight" entire rows where a cell meets a certain condition. That, however, requires you to run the script every time you want to update the highlighting.
I usually just settle for highlighting the cell itself, which is generally easy and usually provides enough visual cues.
SG
os x numbers - conditional formatting
