Hi,

Is it possible to use an IF formula based upon the background colour of the cell. For example I would like to calculate based on

IF(background colour = yellow,1,0)

Similarly can this be used with a COUNTIF formula e.g.

COUNTIF(a1:a8,background colour is yellow)

Thanks for the help

Carl