conditional formatting error

[skittlz]

Hi Everyone,

I'm not trying to do anything 2 complex - just compare 2 dates (due date, last completed date), and highlight everything that is equal to or overdue for calibration. I'm using the formula

=AND(isnumber($K2),IsNumber($L2),$L2<=$K2

Unfortunately, its highlighting the cell ABOVE the value i want it to select.

What is going ON!?!?!

 

[etaf]

=AND(isnumber($K2),IsNumber($L2),$L2<=$K2

you need to change to use row 1
as your selection is L:L and so uses row 1 as the start

=AND(isnumber($K1),IsNumber($L1),$L1<=$K1

Or select from L2:L1000000

 

[LegendaryAxe]

Conditional formatting always uses the first cell in the range you provided as the basis for how it provides conditional formatting for other cells. So L1 is being chosen as the first cell and your formula states that if the K and L cells in the row (K2 and L2) BELOW are numbers, then L1 should have red fill. So any time a row has an L cell and K cell that are numbers, the L cell in the row ABOVE will contain red fill.