I have emulated your code and it works OK for me.

"excelnut1954" wrote:

No. Still getting the 1st line highlighted.
Here's the formula in the range "Deleted_Today"
=COUNTA('Official List'!P6:P4366)
Official List is the name of the worksheet it is looking at for the
entries in column P.
The "Deleted_Today" range is in the worksheet named Touches.

Trying to give you as much as I can.
Thanks for helping me.