I have two columns of prices and I want to do a Conditional Formatting to highlight the cells in the right column if the cost is higher than the cell to the left of it.
For Example:
P3<Q3
P4<Q4
P5<Q5
P6<Q6
...
P40<Q40
I can do this one at at time. What I'm trying to do is see if there's a way to do this for the whole columns at once
For Example:
P3<Q3
P4<Q4
P5<Q5
P6<Q6
...
P40<Q40
I can do this one at at time. What I'm trying to do is see if there's a way to do this for the whole columns at once