Results 1 to 5 of 5

Conditional Formatting causing hair loss!

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Lincs
    MS-Off Ver
    Excel 2007
    Posts
    3

    Conditional Formatting causing hair loss!

    Hi.

    This is probably a very basic question, but as someone relatively new to the features available in Excel its one that is driving me mad.

    I have a column with a combination of blank cells and dates (in a simple UK format, eg. 13/08/2012).

    What I am trying to do is use conditional formatting to highlight just the dates in green if the date is after (ie a future date) tomorrow , and in red if the date is tomorrow, today or any date in the past.

    I've tried looking on line, but have so far drawn a blank.

    Any help would be appreciated, and then perhaps I can stop pulling what little hair I have left out!

    Adrian
    Last edited by ahilder70; 08-13-2012 at 06:27 AM.

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