+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting by date-a group of cells in red

  1. #1
    Registered User
    Join Date
    06-03-2005
    Posts
    5

    Conditional formatting by date-a group of cells in red

    I am trying to highlight a group of cells in red if the date in a certin cell is todays date or older. For example if the date in cell E32 is 10/18/06 or beyond then the group of cells in row one will turn red and stay red until the date in cell E32 is updated to a date in the future. Please help me with the writing of this formula.

    Thanks,

    Dustin

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by dzeitler
    I am trying to highlight a group of cells in red if the date in a certin cell is todays date or older. For example if the date in cell E32 is 10/18/06 or beyond then the group of cells in row one will turn red and stay red until the date in cell E32 is updated to a date in the future. Please help me with the writing of this formula.

    Thanks,

    Dustin
    Formuls is (select the whole range required)

    =$E$32<=TODAY()

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    10-10-2006
    Posts
    22
    Pick a cell and enter say A1

    =TODAY()

    Then use conditional formatting using the cell with the format as your reference. (If cell is <= A1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1