Change Font Color in cell Based on another cell value
Perfect!
Thanks...
--
John
"Bob Phillips" wrote:
This looks like conditional formatting.
select the cells B10,H10, I10
goto CF, FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =$F$4="New"
Pick the Font colour from Format
OK
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John" wrote in message
...
I have a form which uses Validation lists. I'm looking to have the font
color, in Specific Cells (say cells B10, H10,I12, etc.), Change to red
based
on a value selected from a drop down validation list in cell F4 (Value =
"New").
Any help would be appreciated!
--
John
|