Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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


Re: Changing color in cell based on contents

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


Re: Changing color in cell based on contents

Posted by Rohan on October 12, 2001 2:33 PM
:Thats it!! Thanks! turnred Macro Macro recorded 3/24/99 by Karl Barthel


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.