Color formatting using multiple Criteria

[Memar]

I just want to do a color formatting for regional sales in column B (from B2 to B8) using the value in cell A1 and add the total number of the same color/Region in E column (E2 to E5).

Desired Result
[TABLE="width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD][/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[/TR]
[TR]
[TD]WEST[/TD]
[TD]50,000[/TD]
[TD][/TD]
[TD]EAST[/TD]
[TD]=60,000+10,000= 70,000[/TD]
[/TR]
[TR]
[TD]EAST[/TD]
[TD]60,000[/TD]
[TD][/TD]
[TD]WEST[/TD]
[TD]=50,000+25,000= 75,000[/TD]
[/TR]
[TR]
[TD]NORTH[/TD]
[TD]70,000[/TD]
[TD][/TD]
[TD]NORTH[/TD]
[TD]=70,000+25,000=95,000[/TD]
[/TR]
[TR]
[TD]SOUTH[/TD]
[TD]50,000[/TD]
[TD][/TD]
[TD]SOUTH[/TD]
[TD]=50,000 =50,000[/TD]
[/TR]
[TR]
[TD]NORTH[/TD]
[TD]25,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EAST[/TD]
[TD]10,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WEST[/TD]
[TD]20,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help and time.

 

[jtakw]

I just want to do a color formatting for regional sales in column B (from B2 to B8) using the value in cell A1 and add the total number of the same color/Region in E column (E2 to E5).

Hi,

I have No idea what you mean by above in red.

But for Column E, your sample answer for WEST is incorrect:

Book1
	A	B	C	D	E
1	WEST	50,000		EAST	70000
2	EAST	60,000		WEST	70000
3	NORTH	70,000		NORTH	95000
4	SOUTH	50,000		SOUTH	50000
5	NORTH	25,000
6	EAST	10,000
7	WEST	20,000
Sheet420

Cell Formulas
Range	Formula
E1	=SUMIF(A$1:A$7,D1,B$1:B$7)

E1 formula copied down to E4

 

[dave2018]

If I understand correctly, you want something like this:

<a href="https://imgbb.com/"><img src="https://i.ibb.co/Wg11s3L/Capture.png" alt="Capture" border="0"></a>



1. Select cells A2:B8

2. Click ALT+O+D to open conditional formatting dialog.

3. Click New Rule.

4. Under "Use a formula to determine which cells to format" enter =$A2=$A$1 and set a format using the "Format" Button...

5. Click OK.