Hi devpp,
Welcome to board !!
Go to Conditional formatting > Manage Rules > Edit rule > and you can set 'No Cell Icon' wherever you want.
Hi devpp,
Welcome to board !!
Go to Conditional formatting > Manage Rules > Edit rule > and you can set 'No Cell Icon' wherever you want.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
I am ok with the number to displayed.
but when the value is chaged to (say 60) then the icon in one cell changes to yellow color and the other remains red...
my requirement is when the both values are equal then it has to be red icon.when they are not equal then i dont want any icon...
Bookmarks