Formulas for color fill and color text.

[Eamonn100]

Hi,

I have a conditional format using color fill to find certain cells. Is there a way to use a formula that detects color fill or even text color?

 

[Scott T]

Glad to help

 

[Eamonn100]

One question though. What does the 16 stand for in the formula?

 

[Scott T]

The 16 is part of the left function.

LEFT(text,number of characters to return)

Since the text you are looking for is 16 characters the formula is only looking at the first 16 characters of the cell to see if it match's the string you are looking for.

 

[Eamonn100]

No worries. I only asked as I can now use this to find other text. Anyway, I'll have a play about with it and arrays.

Thanks again.