Conditional Formatting help, please
 

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?

Conditional Formatting help, please
 

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?

Conditional Formatting help, please
 

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.

Conditional Formatting help, please
 

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?

Conditional Formatting help, please
 

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

Conditional Formatting help, please
 

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! :)

Conditional Formatting help, please
 

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?