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