Change Font Color in cell Based on another cell value
 

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

Change Font Color in cell Based on another cell value
 

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

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