View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default I want to use an IF Statement in excel to check cell pattern-how?

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 ?