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?

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?

On Jan 18, 4:23*pm, "T. Valko" wrote:
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?- Hide quoted text -

- Show quoted text -

Hi Biff, I am actually using Excel 2007.

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?- Hide
quoted text -

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

Hi Biff, I am actually using Excel 2007.

And you thought that was a good thing to not tell us? <g

Select the range H1:H5
Click "Conditional Formatting" in the Styles panel on the Home tab.
Click "New Rules" on the popup menu that appears.
Click "Use a formula to determine which cells to format"
Enter this into the formula field: =D1<"Y"
Click the Format button and select red for the font color.
OK your way back to the spreadsheet.

Rick

On Jan 18, 4:55*pm, "Rick Rothstein \(MVP - VB\)"
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?- Hide
quoted text -

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

Hi Biff, I am actually using Excel 2007.

And you thought that was a good thing to not tell us? <g

Select the range H1:H5
Click "Conditional Formatting" in the Styles panel on the Home tab.
Click "New Rules" on the popup menu that appears.
Click "Use a formula to determine which cells to format"
Enter this into the formula field: *=D1<"Y"
Click the Format button and select red for the font color.
OK your way back to the spreadsheet.

Rick- Hide quoted text -

- Show quoted text -

Sorry about that! Thanks so much, gentleman, I got it working! :)

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?

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?