how do I search a pattern color & string in excel
 

Hi,
I'd like to know how to look for certain values (and count) in tabs that are
not only identified by their string value but also by their color (the color
generally denoting a certain state). 1 in a white cell is not the same as 1
in a yellow cell. This feature would be particularly useful in Excel but also
in any application tables.
This should be easily done by script, but I hoped this would be built-in.
Suggestions?
Thanks,
Jerome

how do I search a pattern color & string in excel
 

there is no built in capability to do any screening on color.

--
Regards,
Tom Ogilvy


"jayjay17" wrote in message
...
Hi,
I'd like to know how to look for certain values (and count) in tabs that
are
not only identified by their string value but also by their color (the
color
generally denoting a certain state). 1 in a white cell is not the same as
1
in a yellow cell. This feature would be particularly useful in Excel but
also
in any application tables.
This should be easily done by script, but I hoped this would be built-in.
Suggestions?
Thanks,
Jerome

how do I search a pattern color & string in excel
 

Wouldn't it a really nice thing though? Color is just as informative as text
after all...

"Tom Ogilvy" wrote:

there is no built in capability to do any screening on color.

--
Regards,
Tom Ogilvy