conditional formatting at each change in date

[RAJESH1960]

Hello Good Evening Everyone,
I HAVE A LIST OF DATES IN COLUMN B AND AMOUNTS IN COLUMN G. I WANT TO COLOR THE CELL OF COLUMN G AT THE END OF EACH DATE. I TRIED SUBTOTALS AND USE VISIBLE CELLS TO COLOR IT BUT WAS NOT ABLE TO COLOR IT. IS THERE ANY OTHER WAY I COULD DO THAT.

Query to color amounts date wise.xlsx
	A	B	C	D	E	F	G
1	a	b	c	d	e	f	g
2		01-03-2021					843
3		02-03-2021					315
4		02-03-2021					263
5		02-03-2021					575
6		02-03-2021					182
7		02-03-2021					497
8		03-03-2021					890
9		03-03-2021					861
10		03-03-2021					187
11		03-03-2021					402
12		03-03-2021					411
13		03-03-2021					547
14		03-03-2021					526
15		03-03-2021					855
16		03-03-2021					812
17		03-03-2021					562
18		04-03-2021					954
19		04-03-2021					892
20		04-03-2021					951
21		04-03-2021					860
22		04-03-2021					234
23		04-03-2021					231
24		04-03-2021					699
25
qUERY

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1	Cell Value	contains "00141285"	text	NO
D1	Cell Value	="contra"	text	NO

 

[Joe4]

If you want it at the end of each date, and not at the beginning of each date, shouldn't cell G2 be yellow and G3 not have any color?

Here is how you would do that:
1. Select the range G2:G24
2. Go to Conditional Formatting, and enter this CF formula:

=$B2<>$B3

3. Choose the yellow highlighting color

That should do what you want.

 

[RAJESH1960]

If you want it at the end of each date, and not at the beginning of each date, shouldn't cell G2 be yellow and G3 not have any color?

Here is how you would do that:
1. Select the range G2:G24
2. Go to Conditional Formatting, and enter this CF formula:

=$B2<>$B3

3. Choose the yellow highlighting color

That should do what you want.

Yeah. You are right Cell G2 and not G3. My mistake

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	a	b	c	d	e	f	g
2		01/03/2021					843
3		02/03/2021					315
4		02/03/2021					263
5		02/03/2021					575
6		02/03/2021					182
7		02/03/2021					497
8		03/03/2021					890
9		03/03/2021					861
10		03/03/2021					187
11		03/03/2021					402
12		03/03/2021					411
13		03/03/2021					547
14		03/03/2021					526
15		03/03/2021					855
16		03/03/2021					812
17		03/03/2021					562
18		04/03/2021					954
19		04/03/2021					892
20		04/03/2021					951
21		04/03/2021					860
22		04/03/2021					234
23		04/03/2021					231
24		04/03/2021					699
25
26
Test

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G100	Expression	=AND(B2<>"",COUNTIF($B$2:$B$100,B2)=COUNTIF(B$2:B2,B2))	text	NO

 

[Joe4]

OK, did my solution work for you?

 

[RAJESH1960]

Yeah. You are right Cell G2 and not G3. My mistake

Got it Joe4. Perfect

 

[Joe4]

You are welcome.
Glad we were able to help.

 

[RAJESH1960]

OK, did my solution work for you?

yes. Thanks