Excel is displaying the appropriate icons, but you might totally miss that those icons don’t represent the data’s intent. Use conditional formatting There is a fix.

Instead of deleting the Visual Basic code, you can update it to change the shade of Gray that Excel adds to your highlighted cells. Examine the code that you added to the Code window and note that ...