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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies