Changing format

[pablo147]

I was given some help making this spreadsheet to monitor the use of clothing discounts which would alert if any certain person went over $200. At the moment the sheet is set up to where you simply input all details about the purchase and move onto the next. What I'm looking to change is that when inputting a new purchase for a certain person that a separate column or cell contains their running total or cumulative frequency of their amount spent, I'm not very fussed if the layout has to be changed to accomplish this just need the underlying premise that - if a person goes over $200, all cells containing their information will highlight.

Clothing.xlsx
	A	B	C	D	E
1	Date	Team member name	Items	Total amount (Before discount)	Authorising Manager
2	3/06/2023	jacob c	socks x1	11	nathan
3	5/06/2023	will r	boots	85	jackson
4	8/06/2023	sam g	pants x1	15	mat
5	11/06/2023	william j	underwear pack x1	12	dan
6	15/06/2023	will r	pants x2	66	dan
7	16/06/2023	jake h	shirt x1 & pants x1	99	dan
8	20/06/2023	will r	pants x1	55	jackson
9	23/06/2023	william j	socks x3 & shorts x1	40	nathan
10	28/06/2023	jake h	pants x2	100	dan
11	29/06/2023	jake h	pants x1	10	nathan
EXAMPLE

Cell Formulas
Range	Formula
D2	D2	=11
D4	D4	=15
D5	D5	=12
D9	D9	=40

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E12,A13:B13,D13:E14,A14,A15:E50	Expression	=SUMIFS($D$2:$D$50,$B$2:$B$50,$B2)>200	text	NO

 

[sxhall]

Hi Pablo147,

Change the formula in the conditional formatting to the below and the range to be the coumns $A:$E that it applies to. This will then highlight the entire row across the data that sits inside columns A to E...

=SUMIF($B:$B,$B2,$D:$D)>200

Applies to ...

=$A:$E