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

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!
--
D J Hendren

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

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

--
Just me!

Have a safe day.


"DJH" wrote:

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!
--
D J Hendren

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

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" wrote:

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!
--
D J Hendren

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

PERFECT!!! That was exactly what I needed.

Have a terrific weekend!
--
D J Hendren


"Tom Hutchins" wrote:

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" wrote:

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!
--
D J Hendren