+ Reply to Thread
Results 1 to 3 of 3

Stop Light Conditional Formatting HELP?

  1. #1
    Registered User
    Join Date
    01-27-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    2

    Question Stop Light Conditional Formatting HELP?

    I am trying to create a Conditional Formatting to visually show the status of Procedures that are being documented.

    Column F will show whether a Procedure has been documented yet or not. If it has it will show "Y", if not it will show "N"

    So in Column G, I want a Green light to appear if F= "Y"
    and a Red light to appear if F = "N"

    Here is what I have tried, and nothing happens. No light appears in the cell at all.
    In Column G I entered the following formula; =IF(F5="Y","2",IF(F5="N","1",""))

    Then I added a new rule to show:
    Green Light when value is > = 2
    Red Light when <2 and < = 1

    What am I doing wrong? Why does an icon not appear at all on the cell after I do the Conditional Formatting?

    Please Help

  2. #2
    Forum Contributor
    Join Date
    06-30-2015
    Location
    Netherlands
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    145

    Re: Stop Light Conditional Formatting HELP?

    Hi,

    See if this helps.
    Attached Files Attached Files
    HtH,

    Joris

    --------------------------------------------------------------------------------
    If you found my answer helpful, please hit the Like or Thank button.

    Please follow the forum Rules and Guidelines and use Code tags around your VBA code.

    Remember: test VBA code always on a copy of your file because usually you can't use undo

  3. #3
    Registered User
    Join Date
    01-27-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    2

    Re: Stop Light Conditional Formatting HELP?

    It worked! Thank You so much!!

+ 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. Conditional Formatting using traffic light system.
    By nelly7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2016, 02:18 AM
  2. [SOLVED] Conditional formatting + traffic light
    By Kagesen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2016, 05:01 AM
  3. Conditional formatting traffic light formula
    By fumusic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2014, 09:09 AM
  4. Traffic Light Conditional Formatting
    By hzaz in forum Excel General
    Replies: 4
    Last Post: 05-01-2013, 02:10 PM
  5. Need help with traffic light conditional formatting icon set
    By jjospeh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 03:33 PM
  6. Conditional Formatting - Traffic light dates
    By zx561 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2012, 02:51 PM
  7. Conditional Formatting Help-ome light on what I'm doing wrong
    By amsnss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2007, 10:38 AM

Tags for this Thread

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