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.




 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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:

Watch MrExcel Video

Forum statistics

Threads
1,090,491
Messages
5,414,853
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top