Conditional Formatting with Icon Sets

[Davidns]

I just discovered Icon Sets but am a bit confused. I would like a green checkmark to appear if the cell equals 0, and a Red X if it does not equal 0. However, the dialogue box only seems to allow for ">=" or ">".
Any suggestions?
Thanks!

 

[Peter_SSs]

Something like this?

If so, this is how I set it up

 

[Davidns]

Something like this?

View attachment 114648

If so, this is how I set it up

View attachment 114647

Thanks. That works. Just seems like convoluted logic, no? Seems like it should be more straightforward. Anyway, much appreciated!

 

[Peter_SSs]

Just seems like convoluted logic, no?

A bit, but you are wanting to use icon sets conditional formatting in a way it was not designed for so I guess it is expected that it may not be entirely simple.

Anyway, much appreciated!

You're welcome. Thanks for the follow-up.