Try this:

Assuming you're using a version of Excel prior to Excel 2007.

Assume the range of interest is H1:H5
Select the range H1:H5
Goto the menu FormatConditional Formatting
Formula Is: =D1<"Y"
Click the Format button
Select the Font tab
Set the font color to a shade of RED
OK out

--
Biff
Microsoft Excel MVP


"Veronica Johnson" wrote in message
...
I want the font in column H to be red until I enter 'Y' in column D.
What is the formula, and do I use a conditional format to do so?