I can't figure this out, seems like it should be simple.
If B>A then fill red.
My conditional formatting formula is =$B1>$A1
So for the example below I would expect the middle line to be the only one filled.
In my case though the first line is also filled. I found that to be true because blank...