Home

Color Format cell on logic

%3CLINGO-SUB%20id%3D%22lingo-sub-862536%22%20slang%3D%22en-US%22%3EColor%20Format%20cell%20on%20logic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIn%20the%20attached%20workbook%2C%20i%20have%20to%20compare%20the%20*COMPETITOR*%20Worksheet%20with%20the%20*PLAN*%20Worksheet%20on%20plan%20IDs.%20Comparison%20is%20to%20be%20done%20on%20*Interest*%20and%20*Plan%20Details*%20Row.%20The%20logic%20for%20comparison%20is%20given%20in%20worksheet%203%20and%204.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20was%20able%20to%20create%20a%20scripting%20dictionary%20to%20store%20values%20of%20*PLAN*%20worksheet%20to%20compare%20with%20respective%20COMPETITOR%20worksheet%20entries.%20But%20i'm%20not%20able%20to%20compare%20text%20string%20entries.%20Kindly%20help%20me%20out.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862536%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
vicasso
Occasional Contributor

In the attached workbook, i have to compare the *COMPETITOR* Worksheet with the *PLAN* Worksheet on plan IDs. Comparison is to be done on *Interest* and *Plan Details* Row. The logic for comparison is given in worksheet 3 and 4. 

I was able to create a scripting dictionary to store values of *PLAN* worksheet to compare with respective COMPETITOR worksheet entries. But i'm not able to compare text string entries. Kindly help me out. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 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
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies