Conditional Formatting Problem

Bill Brandt

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?

Shaine Greenwood

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).