Greetings,

I have a column of names. Some of these names are in a separate list
and some are not. I have a macro to change the color of the cell of
the names that are not in the list to red. When I find these names
that are not in the list and correct them so that they are now in the
list, the cell color is changed back to white. The problem is in
quickly identifying which workbooks still have uncorrected names in
this column when I open it.

For example: In the CF of D1, If any cell in column D is red, then
change the color of D1 to brown, otherwise, change it to orange
(default color).

Anyone have any ideas on how to write a CF formula to detect if any of
the cells in the target range are red?

Any help will be appreciated.

-Minitman