Forum Discussion
Icon sets in Conditional Formatting working uncorrectly
littlevillage cHANGE TO RULE TO THIS:
littlevillage You say that the result is wrong, but you don't say what it should look like. The rules you used will put a red triangle with every number greater than or equal to zero and a green one with any value less then zero. If that's not what you want you have set the rules incorrectly.
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: