Simple enough in theory. I have a table, 3 columns. Numerator, denominator, and (numerator/denominator). If the (numerator/denominator) column is between 0-30 then I want to shade columns 1 & 2 red, if it's 30-60 green, if it's 60-100 blue.
Simple, right?!
I've never done this type of conditional formatting where you format a cell based on another cells contents. Is this possible?
I am using Office 2007.
Simple, right?!
I've never done this type of conditional formatting where you format a cell based on another cells contents. Is this possible?
I am using Office 2007.