Need cell Color formula

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
 
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 -
Click to expand...

thanks, I'll give it a try
 
Back
Top