Forum Discussion
Solved
Icon sets in Conditional Formatting working uncorrectly
Hi, In column G and K I set rules as the image below But the expect result is failed I have added the link of samplefile below Hope for your help Thank you https://docs.google.com/...
littlevillage cHANGE TO RULE TO THIS:
you are right, I have set the rules incorrectly.
I have set again a new rule:
Put a green triangle with every number greater than 0
Yellow icon with value equal to zero and a Read one with any value less then zero.
the result in column G, the two yellow rows shows green triangle, it must be yellow icon as expect
I setup type values in column G as image below
I have added the link of the samplefile below
Please have a look
Thank you
https://docs.google.com/spreadsheets/d/1cqiwfXlVpV2vaQbzjwmBrAE8phZpvpTs/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true
littlevillage cHANGE TO RULE TO THIS: