I think you have your rows and columns mixed up to start with.

Columns are the letters across the top and rows are the numbers down the
left side.

Which would be the relevant cells and how do you decide?


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 17:03:02 -0700, english4518
wrote:

I have the following basic spreadsheet, and I wanted to use conditional
formating to color the relevant cells Green, but in the example given I can
only apply green to Jan

1 2 3 4 5
A Start End Jan Feb Mar (etc)
B 01/01/10 02/02/10