Can an IF function be based on the color of a cell?

[Blair]

I have cells that are either green, blue or gray in color. Is it possible to have an IF function dependendent on whether the cell color is green or not green (i.e., give one result if green or a second result if either blue or gray)?

 

[yhernandez]

I dont think so. You can do the opposite, make a cell a color based on the values it contains (Conditional Formatting), but I dont think you can make the IF statement use the color (at least not w/out some VBA).

 

[Hui]

Blair


Have a read of this post: http://chandoo.org/forums/topic/cell-colors