Sorry, I know this is simple but I just can’t get it right, I’ve done a search and can’t find the answer and my copy of “Special Edition Using Office” has not been returned!
I have two columns of figures: column Q and column W.
If the result in W2 is greater than Q2, I want the text to be green: if less than Q2, the text must be red.
I can achieve that in conditional formatting easily enough, but can’t work out how to apply that conditional formatting to the *whole* of column W.
At the moment, all i can get is for every cell in W to compare itself to Q2, rather than its relative partner.
In other words, I need W16 to show whether it’s greater or smaller than Q16.
Many thanks for any help
Jim