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 ...
Lior-
Is there anyway you could provide a small non-sensitive sample file with a before and after of a small section of your table? Oftentimes, it can be a lot easier for a community member to resolve your specific inquiry with a small data representation.
Have you looked into conditional formatting color scales?
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.
