Changing color in cell based on contents


Posted by Rohan on October 12, 2001 1:45 PM

Just inherited a ss and cannot figure out how a cell changes color based on its contents.

Basically, the cell has a formula that evaluates to a "R", "G" or "Y", and is then changed into Red, Green or Yellow based on its value. However, I cannot find the actual function/procedure that runs to change the color of the cell. I have unprotected the ss, and unhidden all the hidden worksheets to no avail. The only SUB I see is under Module 1 called turnred:
Sub turnred()
'
' turnred Macro
' Macro recorded 3/24/99 by Karl Barthel
'

'
Selection.Interior.ColorIndex = 3
End Sub

but I cannot find a call to it in any of the sheets. And besides, this sub only handles red, not green and yellow.

What am I missing? What are the other possible ways to change color in a cell based on its value other than a sheet-level macro? Or how else can you hide a macro within a sheet?

Thanks

Posted by Todd on October 12, 2001 1:52 PM

Yes, conditional formatting. Under the Format menu. That's probably what they used. turnred Macro Macro recorded 3/24/99 by Karl Barthel



Posted by Rohan on October 12, 2001 2:33 PM

:Thats it!! Thanks! turnred Macro Macro recorded 3/24/99 by Karl Barthel