Learning Microsoft Excel

[sandy lee lee]

hi lobo,

i work with excel a lot and always run into problems. wish i found this board a few months ago. anyway, is there a way to make a cell count as 1 if the cell is a certain color?

i have a spread sheet - 4 columns

columns one thru three (77 rows long) have either pink or blue fill color depending on the information within. the fourth column i manually enter total of blue cells in that row. is there a format for that 4th column to automatically count blue cells for each row?

tia,

Sandy