Conditional formatting between dates

[ramaxac]

I have a spreadsheet into wich information is added daily (one sheet captures a month's worth of data), and each day has multiple entries. For example, rows 1-10 may be data from 6/1/22, rows 11-20 may be data from 6/2/22, and so on. Column A is simply the date for each entry. To use the previous example, A1:A10 would be 6/1/22 (repeated), A11:A20 would be 6/2/22 (repeated). What I would like is a conditional formatting that would highlight the date change. Maybe it highlights the last 6/1/22 entry or the first 6/2/22 entry... just something that helps me see when the date has changed. I can upload an exmple if needed.

Thanks!

 

[JamesCanale]

simplest thing:

MrExcelPlayground10.xlsx
	A
1	6/1/2022
2	6/1/2022
3	6/1/2022
4	6/1/2022
5	6/1/2022
6	6/1/2022
7	6/1/2022
8	6/2/2022
9	6/2/2022
10	6/2/2022
11	6/3/2022
12	6/3/2022
13	6/3/2022
14	6/3/2022
15	6/3/2022
16	6/3/2022
17	6/3/2022
18	6/3/2022
19	6/6/2022
20	6/6/2022
21	6/6/2022
22	6/6/2022
23	6/6/2022
24	6/6/2022
25	6/6/2022
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A25	Expression	=A2<>A1	text	NO

 

[ramaxac]

simplest thing:

MrExcelPlayground10.xlsx
	A
1	6/1/2022
2	6/1/2022
3	6/1/2022
4	6/1/2022
5	6/1/2022
6	6/1/2022
7	6/1/2022
8	6/2/2022
9	6/2/2022
10	6/2/2022
11	6/3/2022
12	6/3/2022
13	6/3/2022
14	6/3/2022
15	6/3/2022
16	6/3/2022
17	6/3/2022
18	6/3/2022
19	6/6/2022
20	6/6/2022
21	6/6/2022
22	6/6/2022
23	6/6/2022
24	6/6/2022
25	6/6/2022
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A25	Expression	=A2<>A1	text	NO

Perfect - thank you!