Formula that tells which cells are highlited ?

[xtreme07]

I have 10 columns with 2000 rows. some of the rows have either the cell highlighted, either the text highlighted.
i've used conditional formatting for highlighting.

I need to have an 11th column where i can see which one of the rows has at least one of the columns with a highlight of a cell or text.

This result can be displayed by binary number 1 and 0
If you know of a better or more at hand solution, looking forward to it.

Download example for excel 2007:
the demo is NOT using conditional formatting
http://download641.mediafire.com/0585smtyk6ug/4i8b1ip6hgrwchv/Book1.xlsx

 

[cjcobra]

I have excel 2010, but when you put a filter on the cells, you can Filter by text color, highlight, etc.

 

[mikerickson]

Its much much easier to test if the conditions that trigger the formattig are present than it its to test if the conditional formatting is present.

e.g. if a cell is Conditionaly Formatted to turn red when its value is 0, its easier to test if the cell contains 0 than it is to test if it is red.

It sounds like you have a variety of cells with a variety of CF's. Still, testing all those conditions (with OR or AND depending on your needs) is far easier than detecting the (conditionaly) format of the cells