Hi all,
I need some help with a conditional formatting problem I cannot seem to solve.
In the attached sheet I'm trying to insert a traffic light on cell D15. The rules are as follows:
Variance greater than 20% is RED (i.e. D15>20%)
Variance between 10-20% is YELLOW (i.e. D15>10% & D15<20%)
Variance less than 10% is GREEN (i.e. D15<10%)
I'm trying to use the icon sets as shown below.
Icon Sets JPEG.jpg
Conditional Formatting question.xlsx
Why is it not working???
Last edited by Kagesen; 01-07-2016 at 05:02 AM.
you have a whole-number value in D15, but are trying to test it against a percentage. Try converting that -109 to a % opf total
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok thank you for that FDibbins.
If I would like not to convert the number into a percentage, is it then possible to do the conditional formatting a different way?
For example using this?
Icon Sets JPEG.jpg
Here I'm thinking if it's possible to insert an IF formula of some kind?
Think I managed to solve it myself :-)
I created these three formulas to determine which cells to format:
Rule 1: =(ABS(D15)/C15)>0,20 (RED)
Rule 2: =(ABS(D15)/C15)>0,10 (YELLOW)
Rule 3: =(ABS(D15)/C15)<0,10 (GREEN)
However, I cannot use the icons for this so instead the cell goes all red, yellow or green.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks