I have the following in a cell
=IF(OR(K2=I2, K2>I2),"Complete","")
If this is true and the cell contains Complete I want to fill the range A2:S2 with a color instead of being no fill. Is this doable?
I have the following in a cell
=IF(OR(K2=I2, K2>I2),"Complete","")
If this is true and the cell contains Complete I want to fill the range A2:S2 with a color instead of being no fill. Is this doable?
Last edited by CoachBarker; 06-16-2010 at 06:20 AM.
CoachBarker
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks