How do I set conditional formatting to compare cells in 2 columns in Excel 2010?
Posted on 2014-09-30
I am trying to set conditional formatting in column B based on if $B1>$A1 and each corresponding cell down the column. When I enter this formula, highlighting the amounts in column B, the result is based on comparing to only cell A1, no matter what B cell I'm in. For example:
The result should have only column B's 90 and 95 formatted. Not all of B's numbers.
Appreciate the help!