Conditional Formatting - For 1 cell based on contents of any cell

[DJH]

Hi! I'm trying to set up conditional formatting in a column heading cell
where the cell will highlight in red if any of the cells in the rest of the
column have Yes in them.

Example: In Cell A10, I want the cell to highlight red if any of the cells
in A11 thru A100 have Yes in them. Either Yes or No will be entered in each
row of the column.

I'm using Excel 2003.

Thanks!

 

[skm]

In your conditional formatting under 'Format'

Cell Value Is
equal to
="yes" It's imporant that yes be in "" as it's a word.

Hit the Format button
Select the Pattern Tab and choose the color that you want
click OK

At the Conditional Formatting menu, click OK again and you should be all set.

Good luck!!

 

[Tom Hutchins]

Select A10.
Select Format >> Conditional Formatting.
Change 'Cell Value Is' to 'Formula Is'
Enter this formula in the text box:
=COUNTIF($A$11:$A$100,"Yes")>0
Click the Format button.
Click the color Red on the Patterns tab.
Click OK, then OK again.

Hope this helps,

Hutch

 

[DJH]

PERFECT!!! That was exactly what I needed.

Have a terrific weekend!