Simply: For a cell, I want to display a Red icon if the value in that cell is "1"
Alternatively, also display a Green icon if the value = "0"
Intuitively, I'd expect to create a formatting rule like this: Display Red when value = "1" | Type = Number
But, there is no 'equals' operator.
Or, I could say: ... when value >= "1"
Apparently, not as simple as it seems. Having a heck of a time getting the correct icon to display, or any icon at all.
Help please, thanks.
Bookmarks