Results 1 to 9 of 9

Conditional Formatting: Can't get red dot to show up

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2018
    Location
    Redondo Beach, CA
    MS-Off Ver
    2016
    Posts
    13

    Conditional Formatting: Can't get red dot to show up

    So I am trying to set up some conditional formatting using formulas the red/yellow/ green icons. The green and yellow icons seem to be capturing correctly for some reason I can't get the red icon to show up.

    Conditional format.PNG

    Here is the formulas I put in. I want it to be green if they exceed their goal, yellow if they reach 80% of the goal, and red for anything lower.

    results.PNG

    As you can see, the fourth column should be red, as they did not meet 80% of the goal, but it still shows up as yellow. I can't figure out how to include the red icon in this table. And I am already aware that there needs to be a separate rule for each line.

    Any advice would be appreciated!
    Attached Files Attached Files
    Last edited by stell64; 01-17-2019 at 03:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Header doesn't show conditional formatting
    By Jackxel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-09-2018, 05:11 AM
  2. [SOLVED] Conditional formatting to show difference
    By Shamz41 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-10-2018, 03:43 AM
  3. conditional formatting to show blank cells
    By Shamz41 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2018, 09:25 AM
  4. Conditional Formatting to show if a formula has been changed
    By Grimwood in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2013, 12:06 PM
  5. Conditional Formatting to show biggest reductions in %
    By LDouble3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 11:45 AM
  6. Replies: 0
    Last Post: 07-31-2012, 06:09 PM
  7. Conditional Formatting to show age of invoice?
    By leven in forum Excel General
    Replies: 9
    Last Post: 06-08-2012, 09:31 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