Catalin,
I just went back into those blank cells and pressed delete and the conditional formatting worked - those rows are turning red now. The cells must have had a space in them? I am guessing I'll need to go through and make sure all the blank cells are really blank.

Laurie B.