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

Vicasso

New Member
Joined
Sep 9, 2019
Messages
6
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

Well-known Member
Joined
Aug 19, 2003
Messages
5,615
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.
 
Last edited:

Forum statistics

Threads
1,085,968
Messages
5,387,038
Members
402,031
Latest member
udn3939

Some videos you may like

This Week's Hot Topics

Top