Try this link to Chip Pearson's site:
http://www.cpearson.com/excel/colors.htm
A user-defined function can return the background colour of a cell, so
you could use this in your formula.
Hope this helps.
Pete
Aidan wrote:
I am using nested IF staements to check value conditions of cells. As wel as
checking for blanks and acceptable values I want to check if the Cell Pattern
< Red. Can this final check be done in the IF statement.
Appreciate any help ?