Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Conditional format of date (XP)

    I have this spreadsheet and in cell F16 is a date, say 10 September 2005. When it becomes 11 September or later, I would like this to charge, either the font colour or the colour of the cell. So it will work on the computers settings.
    I've tried all sorts of combinations using conditional formatting, but none really works.
    I know I can use an IF formula, but the workbook will have many sheets with many dates and be used by someone not to computer litterate, so I want it full proof.
    Thanks for the help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional format of date (XP)

    Select F16.
    Select Format | Conditional Formatting...
    Leave the first combo box to the default Cell Value Is
    Select Less Than from the second combo box.
    Enter the formula <code>=TODAY()</code> in the box next to it.
    Click the Format... button and specify the way you want the cell to look when its value is before the current date.
    Click OK twice.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Conditional format of date (XP)

    You may want to provide more detail if you have a more complicated worksheet. For the single example you provide, this is not difficult - in the graphic attached, cell B1 contains the day before, 9/10/2005. Other ways of doing this would be to hard-code the formula as

    =DATEVALUE("9/10/2005")

    (Assuming you are using US based dates.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Conditional format of date (XP)

    Thanks, that worked a treat..
    And I'm not in the states, I'm from sunny New Zealand where the spring started on the 1st September.

    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •