Results 1 to 7 of 7

conditional formatting - Traffic light effect

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    London
    MS-Off Ver
    16.38
    Posts
    7

    conditional formatting - Traffic light effect

    I am in need of some help - I have made a few new rules up under conditional formatting so when a date is entered it goes amber 3 days before the date and red on the date within the column G. I also have the rule that when a date is entered into column I the date in column G will go blank. Im looking instead of the I column going black to fill the cell green so at a quick glance we know this has been looked at. Please see my screen shot.Thank you in advance!

    The rules I have set already in order are -

    Formula:=OR(ISBLANK(G1),I1<>"") Format - no fill applies to - Sheet1!$F:$F stop if true - ticked
    Cell Value < NOW() Format - red applies to - Sheet1!$F:$F stop if true - unticked
    Cell Value < NOW()+3 Format - amber applies to - Sheet1!$F:$F stop if true - unticked
    Attached Files Attached Files
    Last edited by georgiaaamayyy; 07-21-2020 at 08:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting based on another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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