Hi
Have a look here for some help:
http://www.cpearson.com/excel/colors.htm
Andy.
"eehinmd" wrote in message
...
I have a workbook that uses the fill color as a dimensionof the data (
currecy of training). I want to automate statistics without counting
cells
and entering the number. I would like to do some thing like countif the
fill
is red. IS there a way to set the fill value to a variable to count with?