Replies to post #60 on Learning Microsoft Excel

[Susie924]

I'm doing a monthly spreadsheet going back to January, 2000
The first column should have the month and year all the way down.

I've been manually typing it but I know there's a better way.

I am up to 2005 now so it won't take much longer.

[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