If you mean -

a) The range has been applied with CF's and you want to know if any of the
cells show the CF format because of a true condition, see Nick's suggestion.

or

b) You want to know if CF's have been applied to any cells in the range,
regardless as to whether any conditions are true and one or more CF formats
display, see Norman's suggestion.

The latter is the correct literal interpretation of your question. But
somehow I suspect you mean the former. (?)

Regards,
Peter T


"Patrick Simonds" wrote in message
...
Using conditional formatting, is there any way to turn Cell A1 red if a
conditional format has been applied to any cells in the range D1:H1?