Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format - Date + 7 | Excel Discussion (Misc queries) | |||
Conditional Format is date is Sat or Sun | Excel Discussion (Misc queries) | |||
Conditional format when date is near | Excel Worksheet Functions | |||
Date Conditional Format | Setting up and Configuration of Excel | |||
Conditional Format - Date | New Users to Excel |