Conditional Format Formula Help
 

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

Conditional Format Formula Help
 

See http://www.xldynamic.com/source/xld.CFConditions.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Minitman" wrote in message
...
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

Conditional Format Formula Help
 

Thanks Bob,

I hadn't considered a function - works great!

-Minitman

On Fri, 27 Nov 2009 14:34:02 -0000, "Bob Phillips"
wrote:

See http://www.xldynamic.com/source/xld.CFConditions.html