cell formats

[bob]

Does anyone know how to find formatted cells using a
formula? For example: I want to know how many cells are
conditionally formatted RED because they met some other
condition.

 

[Norman Harker]

Hi Bob!

This is complicated because "normal" functions that count based upon
color format don't count based upon conditional format applied colors.

However, see Chip Pearson link which does allow a count based upon the
conditional format:

http://www.cpearson.com/excel/CFColors.htm

But it may be easier to count the cells using the conditional format
algorithm. For example if you have conditionally formatted as red all
cases where the value is greater than 14, then you could use COUNTIF
with that criteria.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.