SOLVED

Icon sets in Conditional Formatting working uncorrectly

Iron Contributor

Hi,

In column G and K I set rules as the image below

small_village_0-1659582486692.png

But the expect result is failed

small_village_1-1659582611987.png

I have added the  link of samplefile below

Hope for your help

Thank you

https://docs.google.com/spreadsheets/d/1g2tVv62pYkGwFcE8dJKiWz6W3KdtEEiD/edit?usp=sharing&ouid=11231... 

4 Replies

@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.

@Riny_van_Eekelen 


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

small_village_0-1659596232741.png

 

I setup type values in column G as image below

 

small_village_1-1659597306168.png

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=11231... 

best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage cHANGE TO RULE TO THIS:

Screenshot 2022-08-04 092416.png

@Riny_van_Eekelen 

Thank you for your help

It works correctly

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)