There is no standard function in Excel to return the background colour
of a cell - you have to make your own, and that means a bit of VBA.
Pete
Aidan wrote:
Thanks Pete,
Good link but unfortunately I do not want to have to use VBA
Regards
Aidan
"Pete_UK" wrote:
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 ?