Formulas can't see colors. How did the color(s) get into the cell... by
Conditional Formatting or manually? If by Conditional Formatting, then you
should be able to use its formula as your test condition. If manually
placed, then you will need VB code. Either way, I think you will have to
supply a more detailed description of what you are attempting to do.

--
Rick (MVP - Excel)


"Robert Temple" <Robert wrote in message
...
Is there any formula to identify if a range of cells have a color fill?