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
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
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
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies