Color cells of a worksheet by comparing entries with other worksheet.

[Vicasso]

In the attached workbook, i have to compare the *COMPETITOR* Worksheet with the *PLAN* Worksheet. The comparison is to be done between Plans Premium, Plan_Amount and Item 1 Price in both the sheets and conditionally format the Competitor worksheets entry as blue and red depending on the values( if lower or higher than the values in Plan worksheet).


I have to automate this step along multiple sheet(for different states). Kindly help me out here. Apologies for lack of clarity,
i will try to frame the question in a better way if it's not clear.

 

[onlyadrafter]

Hello,

In the Competitor tab, cell B4 add these two conditional formats:

=HLOOKUP(B$3,Plan!$B$1:$E$5,ROW()-1,0)>B4

and

=HLOOKUP(B$3,Plan!$B$1:$E$5,ROW()-1,0) < B4 (no spaces)

format as requried.

Use the format painter to format other cells in the Competitor tab.