Forum Discussion
Comparing the data of 2 columns
Hi I have 2 separate column with different numeric values and I want to compare the value of first column with the value of second column. If it is less I want to highlight it as red if it is greater...
Highlight the values in Column B and use these conditional formatting formulas, assuming your data starts in Row 2:
For Red =B2<A2
For Green =B2>A2
Note that no highlighting will occur if the value in Column B is equal to that of Column A.
For Red =B2<A2
For Green =B2>A2
Note that no highlighting will occur if the value in Column B is equal to that of Column A.