Conditional Format Icons

[Cmorgan]

Morning,

Any help would be appreciated. I am using 'conditional formatting' to place icons in the cells - the icons set is the one which has tick, cross and exclamation mark.

- Really all I want to show up is the icon and not the numerical value. So I have just added another conditional formatting rule, which changes the number to a white font, so you can't see it.
- I want to try to get the icon in the middle of the cell but can't seem to, is there any way to do this? When I try centering, it just moves the numerical value in the cell, and the icon remains tied to the left hand side of the cell.

Thanks

[vlady]

Good day!

In the Conditional formating "ICON SETS" below there is the "MORE RULES" select that one
then tick the box that says "SHOW ICONS ONLY" note that this will hide the values no need to color it white
Edit: you can then apply alignment

[Cmorgan]

Many thanks for this

[vlady]

Your very much welcome.

regards,
vladimir