Conditional formatting not working with simple formula
I am trying to highlight rows where column H is greater than 7 but its is not working. Rows are being highlighted where H>=7 and less that the highest number in the sequence. It looks like the formatted rows are moving up one row. See the attached picture for the formatting rule and the result. Any help on this problem would be appreciated.
|