Forum Discussion

Harman_0013's avatar
Harman_0013
Copper Contributor
Apr 09, 2019

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 then green. I tried conditional formatting but that didn't helped me. Can u please suggest me the possible solution to tha.

excel

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 09, 2019
    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.