Conditional format for date
 

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?

Conditional format for date
 

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?

Conditional format for date
 

Hi,

Step 1: Select the entire columns A and B (by left-clicking on "A" in the
column-label bar above Row 1, and dragging, while holding the mouse-button,
to "B").
Right click anywhere in the selcted area -- Fomat Cells -- Fill tab --
pick the color you desire to have for even numbered years.

Step 2: Select the entire columns A and B as in Step 1. "Conditional
Formatting" --"New Rule"-- "Use a formula..." -- in the formula box enter
the formula
=ISODD(YEAR($A1)) -- "Format" button-- "Fill" tab -- select the color you
desire to have for odd numbered year rows -- "OK"-- "OK".

Step 3: Repeat Step 2, but with the formula, =ISBLANK($A1). This time for
the fill color select "No color"

Hope this works. If this helps, please give a feedback by clicking the
"Yes" button.

Regards,
B. R. Ramachandran




":)" wrote:

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?

Conditional format for date
 

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?


.

Conditional format for date
 

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?


.