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

0 Replies