Conditional Statements looking at colors?

[taurus99]

Can you create a conditional statement that looks at the color of another cell?

For example:

I need column BN to look at column AX, if AX is RED, column BN needs to say
FALSE.

I have too many different values in AX, or I would use an actual value in my
conditional statement for column BN.

Thanks!

 

[Pete_UK]

You can't do that with one of the standard Excel functions, but it is
relatively easy to devise your own User Defined Function to read the
color index of a cell. Bob Phillips show how here:

http://www.xldynamic.com/source/xld.ColourCounter.html

and goes on to give many examples of how you can use such a function.

Hope this helps.

Pete

 

[taurus99]

Thank you for the feedback. However, I read through the information and found
it won't work for me because the colored cells I am working with were colored
using conditional formating. UGH!

 

[Pete_UK]

Well in that case it is possible to use the conditions that you
applied for your CF within the formula. For example, suppose your
cells in column AX turn red if their value is above 50 - in BN1 you
can put this formula:

=AX1<=50

This will return FALSE if AX is above 50 (i.e. red) and TRUE
otherwise.

Hope this helps.

Pete