Automatically colour fill cells

[svn_pie]

Hi

I have four worksheets in an excel file August, September, October and NOvember. Each sheet contains the same matrix/table. The left most column contains a list of projects. i have adopted a stoplight style for reporting i.e the certain cells are filled either red, green, amber based on the result in that field. What i would like to do is put some code behind each cell so that if it for example the results is 50 then it automatically turns red, or amber etc based on the code behind the cell.

Also i would like to put totals at the bottom of each field so that it counts the number of red cells, green cells etc.

How is this possible? can anyone help me with these two problems

[mrice]

Sounds like you need conditional formatting to generate your colours and the COUNTIF function to sort out the counts of each colour (indirectly by counting the underlying values that the conditional formatting is using)

[svn_pie]

I thought that. Any idea how to apply this then, how to set the function out?

[mrice]

Its easiest in Excel 2007 where the new COUNTIFS function is available

=COUNTIFS(A:A,">0",A:A,"<=50")

gives a count of all values greater than 0 and less than or equal to 50.