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

A1	B1		D1	E1
WEST	50,000		EAST	=60,000+10,000= 70,000
EAST	60,000		WEST	=50,000+25,000= 75,000
NORTH	70,000		NORTH	=70,000+25,000=95,000
SOUTH	50,000		SOUTH	=50,000 =50,000
NORTH	25,000
EAST	10,000
WEST	20,000

<tbody>
</tbody>

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.