Forum Discussion
Lior Yosub
Apr 26, 2018Copper Contributor
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 Yosub
May 06, 2018Copper Contributor
Here's a sample file.
SergeiBaklan
May 07, 2018Diamond Contributor
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.
- Lior YosubMay 13, 2018Copper Contributor
Thank you!
That works perfectly.