Results 1 to 5 of 5

Condittional Formatting: Range of days

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2007
    Posts
    31

    Condittional Formatting: Range of days

    Hi, I need help to come up with the following conditional formatting:

    Color cell AB3 in red if B3 shows the word OPEN and the date on AA is -1 day, -2 days, 0 day, 1day, 2 days... 50days from today (a range from -2 days to +50 days from the current date)

    Could anyone kindly help me? I quite confused trying to figure this out
    Attached Files Attached Files
    Last edited by Kinna; 05-29-2009 at 09:17 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