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