Conditional Formatting Problem

Bill Brandt
Bill Brandt ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a rule that say's if % Complete is blank make the cell red. This is not being applied to all the cells that meet this criteria. I have deleted the offending cells to make sure there was no stray data and even copy and pasted a working cell into a non working cell. Any ideas on what to look at?


  • Hi Bill,

    Happy to help, can you provide me with 2 screenshots:

    1. Your conditional formatting rule. (In the Conditional Formatting window)
    2. A screenshot of one of the offending rows, with the cell history window opened (right-click the cell and select View Cell History).