Need cell Color formula

[Steve]

Can anyone tell me of a formula I can use that will tell me if an
adjacent cell is a certain color to have the result be "True" and if
there is no color the result be "False"?


Thanks,

Steve

 

[Gord Dibben]

Excel functions do not recognize colors.

You would need VBA to check for color.

UNLESS the color is induced by conditional formatting.

In that case, test for the value that colors the cell.

For a User Defined Function to determine cell colors see Chip Pearson's site.

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


Gord Dibben MS Excel MVP

 

[Steve]

Excel functions do not recognize colors.

You would need VBA to check for color.

UNLESS the color is induced by conditional formatting.

In that case, test for the value that colors the cell.

For a User Defined Function to determine cell colors see Chip Pearson's site.

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

Gord Dibben  MS Excel MVP





- Show quoted text -

thanks, I'll give it a try