Forum Discussion
Smart Conditional formatting
I hope this is the right place to ask. I have a table for each exam. In the top row I have the names of the question and in the second row the maximum grade for that question. I want to use a color ...
Here's a sample file.
Hi Lior,
For max number in your rule you may use the formula like
=OFFSET($B$3,0,COLUMN()-COLUMN($B$3))
apply it to any of your columns; and apply formatting by format painter to any other columns you'd like to colour.
Please see second sheet in attached.
Thank you!
That works perfectly.