I have a specific problem I would like to solve. I would like to highlight cells in the N column if the K and/or L columns in the same row are a larger value. L is not always filled, but if necessary I could make it so it is.
i’ve tried getting conditional formatting to work with no luck yet.
New contributor
Evert Mussche is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Entered in cell N2 and applied to $N$2:$N$x (where x is the last row of data):
=AND($N2<>"",OR($K2>$N2, $L2>$N2))