+ Reply to Thread
Results 1 to 4 of 4

date conditional formatting

  1. #1
    Registered User
    Join Date
    01-16-2008
    Location
    Essex
    Posts
    25

    date conditional formatting

    Hi, help needed please

    Cell A1 is todays date

    column A issue date of form

    column B reminder date of form due back (I would like this cell to turn red if the date has expired )

    column C final reminder date to return form (I would like this cell to turn red if the date has expired)

    column D received date of form returned (when this cell is completed I would like the cells A and B to show yellow)


    Can anyone help please
    Thank you,
    Jackie

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    say you start in row 4
    conditional format a4
    condition 1
    formula is
    =ISNUMBER(D4)
    choose yellow cell colour

    conditional format b4
    condition 1
    formula is
    =ISNUMBER(D4)
    choose yellow cell colour

    condition 2
    formula is
    =B4<$A$1
    choose red cell colour

    conditional format c4
    condition 1
    formula is
    =C2<$A$1
    choose red cell colour

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    Attched is an example very much along the lines of martin's description
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-16-2008
    Location
    Essex
    Posts
    25

    Date formatting

    Thanks guys - will be giving this a go

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 07-23-2008, 06:59 AM
  2. Conditional Formatting based on date passed
    By windme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-05-2008, 10:54 AM
  3. Excel 2007 conditional formatting bug
    By jmessina in forum Excel General
    Replies: 0
    Last Post: 04-28-2008, 09:09 AM
  4. Conditional Formatting - Date dependancy
    By Whitewidow in forum Excel General
    Replies: 2
    Last Post: 11-14-2007, 10:37 AM
  5. Conditional formatting by date-a group of cells in red
    By dzeitler in forum Excel General
    Replies: 2
    Last Post: 10-18-2006, 09:15 PM

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