tweaking conditional formatting

kwvh
3StarLounger
Posts: 308
Joined: 24 Feb 2010, 13:41

tweaking conditional formatting

Post by kwvh »

I am trying to find a solution, which may be easy, but it eludes me. I would like to have something similar to the attached, but NOT display the "X". Instead just leave the white font on red background, when the value dictates.

Would want to leave the green check mark as is, as well as the "O". Is there a simple solution? Or any solution?

Thank you for your consideration.

Ken
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: tweaking conditional formatting

Post by HansV »

Select the range with the icons.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Select the relevant rule (if necessary), then click Edit...
Click the dropdown that displays the red "X", and select "No Cell icon" from the dropdown list.
Click OK, then OK again.
S0930.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

kwvh
3StarLounger
Posts: 308
Joined: 24 Feb 2010, 13:41

Re: tweaking conditional formatting

Post by kwvh »

Wow! So easy.

Thank you, Hans!!