Home

Comparing the data of 2 columns

%3CLINGO-SUB%20id%3D%22lingo-sub-422018%22%20slang%3D%22en-US%22%3EComparing%20the%20data%20of%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-422018%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%202%20separate%20column%20with%20different%20numeric%20values%20and%20I%20want%20to%20compare%20the%20value%20of%20first%20column%20with%20the%20value%20of%20second%20column.%20If%20it%20is%20less%20I%20want%20to%20highlight%20it%20as%20red%20if%20it%20is%20greater%20then%20green.%20I%20tried%20conditional%20formatting%20but%20that%20didn't%20helped%20me.%20Can%20u%20please%20suggest%20me%20the%20possible%20solution%20to%20tha.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-422018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-422386%22%20slang%3D%22en-US%22%3ERe%3A%20Comparing%20the%20data%20of%202%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-422386%22%20slang%3D%22en-US%22%3EHighlight%20the%20values%20in%20Column%20B%20and%20use%20these%20conditional%20formatting%20formulas%2C%20assuming%20your%20data%20starts%20in%20Row%202%3A%3CBR%20%2F%3EFor%20Red%20%3DB2%3CA2%3E%3CBR%20%2F%3EFor%20Green%20%3DB2%26gt%3BA2%3CBR%20%2F%3ENote%20that%20no%20highlighting%20will%20occur%20if%20the%20value%20in%20Column%20B%20is%20equal%20to%20that%20of%20Column%20A.%3C%2FA2%3E%3C%2FLINGO-BODY%3E
Highlighted
Harman_0013
Occasional Visitor

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.

1 Reply
Highlighted
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.
Related Conversations