Why the IF(...,0,1) ?
Why not just =D2<"Y" ? (or =D1<"Y" if the active cell is H1 as suggested)
--
David Biddulph

"FSt1" wrote in message
...
hi
yes conditional formatting.
select H1 then on the menu bar...Formatconditional formatting.
when the conditional formatting dialog box comes up, enter
formula is......=IF(D2="Y",0,1)....pick your format.
copy H1 and paste as far down as you need.

Regards
FSt1

"Veronica Johnson" wrote:

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?