Conditional Formatting Not Working

aschneiderheinze1025

I have a conditional formatting rule that says when [H-Public View Enrollment (Go-Live Date, Check)] is checked, change formatting of [Public View Enrollment (Go-Live Date)] to red background, white text.

The rows in which this is true do, in fact, change their formatting. But, all of the other rows that don't meet this condition are still red/white text.

I tried disabling the rule, and all the rows turn back to normal (no red background), so I know there isn't another rule that is causing the cells to be formatted differently.

This is the formula in [H-Public View Enrollment (Go-Live Date, Check)]:

=IF(AND(NOT(ISBLANK([Section (Start Date)]@row )), ISBLANK([Public View Enrollment (Go-Live Date)]@row )), 1, 0)

Only the first four rows are checked, yet all the rows are shaded red.

Paul Newcome

Try enabling the rule, clicking on the column header, then clicking on the eraser in the top toolbar to remove formatting. Is it that formatting was applied to the column directly instead of conditional formatting?