Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


":)" wrote in message
...
Hi Biff,

I am using Office 2007. Thanks for responding. Ramachandran has solved my
enquiries. Happy new year to both of you.

"T. Valko" wrote:

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


":)" wrote in message
...
I have a list of dates (column A) say from 01/01/2005 to present and
attaching values at column B. Is it possible to have a conditional
format
where the cells will be filled with colours upon data entry? Secondly,
the
colours need to be arrange such that for an even year (2006,2008), the
cells
is filled with a particular colour, together with the column B values.
And
for odd years (2005,2007,2009), both cells are in another colour?


.