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
Kindly tell me why my conditional formatting had gone wrong. Thank you.
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
Kindly tell me why my conditional formatting had gone wrong. Thank you.
