I'm working with a spreadsheet that I got elsewhere and tried to add conditional formatting to it. However, I can't.

The excel file was to large to upload so I took screenshots. The checkbox in cell E3 links to cell E8. Cell E9 was conditionally formatted to turn red when cell E8 = TRUE.

the first screenshot ("before") is before any formatting is initiated.

the second screenshot ("after") is when the checkbox is clicked and the value in E8 = TRUE. However, in cell E9, it appears as though the grey that was there before is like an image that is "in front" of the cell's color. You can see the red peaking through a little bit.

the third screenshot ("after highlight") is what happens if I highlight the area.... the red then shows through.

What the heck is happening here? How do I get this conditional formatting to work?

before.jpg

after.jpg

after highlight.jpg