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.
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.