Conditional Formatting - Icon Set

Jen_Kat

New Member
Joined
May 29, 2021
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
Appreciate if I can get some guidance.

I had set the criteria for the RYG icons (per pic below) but the result in the worksheet is incorrect. Just take the first row as example - at 67%, it should show GREEN button but it became Yellow.
I am looking at using this table to track stock movement.

Criteria:
If last six month qty is more than 1 and that YTD2021 vs Y2020 is more than 40%, "GREEN".
If last six month qty is more than 1 and that YTD 2021 vs Y2020 is <40% but more than 10%, "YELLOW"
If last six month qty is more than 1 and YTD 2021 vs Y2020 is <10%, "RED"

Under Input, I want to include conditional formatting to reflect the following:

If activity status is RED and INPUT is >=1, Cells becomes RED


Rule1.JPG
Rule2.JPG


Kindly tell me why my conditional formatting had gone wrong. Thank you.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
Change it Type Percent to Number & values of 0.4 and 0.1
 
Solution

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,252
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,141,073
Messages
5,704,138
Members
421,328
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top