Color Format cell on logic

Copper 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