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?