Need cell Color formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 03 Jan 2008 21:46 GMT

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

Reply to this Message

Gord Dibben - 03 Jan 2008 22:43 GMT

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

>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
[quoted text clipped - 3 lines]
>
>Steve

Reply to this Message

Steve - 04 Jan 2008 18:55 GMT

> Excel functions do not recognize colors.
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -

thanks, I'll give it a try

Reply to this Message