Sign in to submit new ideas and vote
Get Started

Dynamic View - Conditional Formatting in Blank Cells

Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color.

As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the cell color in blank cells was still not working.

See screenshots below (first screenshot is of the dynamic view with incorrect colors; second is a screenshot of the source sheet showing the correct formatting).

I already posted this in Get Help, and there were workarounds suggested but no real solution. I am requesting Dynamic View be improved so that this bug doesn't occur. Thanks!

2
2 votes

Idea Submitted · Last Updated