Coloring rows based on identical dates

[HowToDoIt]

I have a spreadsheet with several entries/rows on the same date, 10/10/24, for example. I'd like all rows on that date to be colored blue. Then I want the next rows on a subsequent date, to be yellow. The next three or more rows of the date following that should revert to blue, and all the rows with the date after that to go back to yellow and follow that alternating pattern of blue to yellow for the full length of the sheet. You'd have, say, three blue rows followed by three or more yellow rows followed by several blue rows followed by several yellow rows. Is that possible through, maybe, the conditional formatting feature or by yet some other approach? A simple "no" will do, but if the answer is yes then please tell me how to do it. I'd be most appreciative. I don't use Excel very often, so it's just not an issue I've ever previously dealt with.

 

[Joe4]

Welcome to the Board!

Questions like this often make a lot more sense when you can show us a sample of your data and expected results, so we can see exactly what the data you are working with looks like and what you want your results to look like. Can you post those?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Skyybot]

Does your Data look something like this?

Book1
	A	B	C	D	E	F
1	Some Header	Some Header	Some Header	Some Header	Some Header	Some Header
2	10/10/2023
3		Some Data	Some Data	Some Data	Some Data	Some Data
4		Some Data	Some Data	Some Data	Some Data	Some Data
5		Some Data	Some Data	Some Data	Some Data	Some Data
6	10/20/2023
7		Some Data	Some Data	Some Data	Some Data	Some Data
8		Some Data	Some Data	Some Data	Some Data	Some Data
9		Some Data	Some Data	Some Data	Some Data	Some Data
10		Some Data	Some Data	Some Data	Some Data	Some Data
11	10/30/2023
12		Some Data	Some Data	Some Data	Some Data	Some Data
13		Some Data	Some Data	Some Data	Some Data	Some Data
Source Sheet 1

 

[HowToDoIt]

Thanks. What I'm trying to do is obtain my blood pressure in the morning, mid-day, and in the evening before bed. We're trying to get my BP meds pressure adjusted. Color coding by date would help. I'll post the spreadsheet image. I'm on a Mac, and the xl2bb file doesn't seem to install. The screeshot I created on my computer was too large to upload.

 

[HowToDoIt]

Does your Data look something like this?

Book1
	A	B	C	D	E	F
1	Some Header	Some Header	Some Header	Some Header	Some Header	Some Header
2	10/10/2023
3		Some Data	Some Data	Some Data	Some Data	Some Data
4		Some Data	Some Data	Some Data	Some Data	Some Data
5		Some Data	Some Data	Some Data	Some Data	Some Data
6	10/20/2023
7		Some Data	Some Data	Some Data	Some Data	Some Data
8		Some Data	Some Data	Some Data	Some Data	Some Data
9		Some Data	Some Data	Some Data	Some Data	Some Data
10		Some Data	Some Data	Some Data	Some Data	Some Data
11	10/30/2023
12		Some Data	Some Data	Some Data	Some Data	Some Data
13		Some Data	Some Data	Some Data	Some Data	Some Data
Source Sheet 1

No, but that certainly looks like a good idea.

 

[HowToDoIt]

Welcome to the Board!

Questions like this often make a lot more sense when you can show us a sample of your data and expected results, so we can see exactly what the data you are working with looks like and what you want your results to look like. Can you post those?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

So I booted Parallels and then Excel in Windows. It looks very different. I did manage to get the XL2BB installed, and I clicked on it. It sent me back to this forum. Now I'm trying to get my spreadsheet image uploaded (or whatever the XL2BB is) and can't seem to figure out that part of it.

Welcome to the Board!

Questions like this often make a lot more sense when you can show us a sample of your data and expected results, so we can see exactly what the data you are working with looks like and what you want your results to look like. Can you post those?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[HowToDoIt]

Welcome to the Board!

Questions like this often make a lot more sense when you can show us a sample of your data and expected results, so we can see exactly what the data you are working with looks like and what you want your results to look like. Can you post those?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

bpm_readings_export_26122023_105534.csv
	A	B	C	D	E	F
1	Date	Time	Systolic (mm Hg)	Diastolic (mm Hg)	Heart Rate (bpm)	Risk Category Index (American Heart Assoc. 2017)
2	12/26/23	10:05 AM	113	79	79	Normal
3	12/25/23	6:56 AM	147	92	70	Stage 2
4	12/24/23	10:38 PM	148	86	77	Stage 2
5	12/24/23	10:04 AM	161	93	72	Stage 2
6	12/24/23	8:13 AM	168	92	72	Stage 2
7	12/23/23	8:05 AM	133	92	77	Stage 2
8	12/23/23	8:04 AM	150	84	76	Stage 2
9	12/23/23	6:21 AM	177	101	70	Stage 2
10	12/22/23	5:37 PM	132	77	84	Stage 1
11	12/22/23	11:24 AM	122	77	84	Elevated
12	12/21/23	9:40 PM	138	85	85	Stage 1
13	12/21/23	1:48 PM	109	73	88	Normal
14	12/21/23	9:27 AM	118	81	83	Stage 1
15	12/21/23	7:10 AM	150	87	72	Stage 2
16	12/20/23	9:31 PM	120	75	80	Elevated
17	12/20/23	2:43 PM	94	70	85	Normal
18	12/20/23	1:19 PM	87	70	84	Normal
19	12/20/23	9:21 AM	109	72	90	Normal
20	12/20/23	8:36 AM	123	82	82	Stage 1
21	12/20/23	8:32 AM	135	90	74	Stage 2
22	12/20/23	8:31 AM	122	77	76	Elevated
23	12/19/23	9:49 PM	162	87	70	Stage 2
24	12/19/23	9:52 AM	174	102	65	Stage 2
25	12/18/23	8:31 PM	164	96	72	Stage 2
26	12/18/23	2:26 PM	163	95	70	Stage 2
27	12/18/23	11:04 AM	173	96	68	Stage 2
28	12/15/23	9:26 PM	188	104	66	Crisis
29	12/15/23	7:28 AM	170	93	61	Stage 2
30	12/14/23	12:07 PM	179	109	55	Stage 2
31	12/14/23	11:32 AM	178	104	56	Stage 2
32	12/14/23	11:27 AM	178	96	57	Stage 2
33	12/13/23	12:56 PM	161	90	62	Stage 2
bpm_readings_export_26122023_10

 

[HowToDoIt]

Welcome to the Board!

Questions like this often make a lot more sense when you can show us a sample of your data and expected results, so we can see exactly what the data you are working with looks like and what you want your results to look like. Can you post those?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

So I booted Parallels and then Excel in Windows. It looks very different. I did manage to get the XL2BB installed, and I clicked on it. It sent me back to this forum. Now I'm trying to get my spreadsheet image uploaded (or whatever the XL2BB is) and can't seem to figure out that part of it.

 

[Joe4]

It looks like you successfully managed to post your image up in post #7, though I do not see any color coding.
I would really like to see what you expect your output to look like, so we can get a full picture of how this should be working.

 

[HowToDoIt]

It looks like you successfully managed to post your image up in post #7, though I do not see any color coding.
I would really like to see what you expect your output to look like, so we can get a full picture of how this should be working.

I would like the color coding to resemble something like the image below: all readings on a particular date being the same color followed by another color for a subsequent date. It will make it easier to see how the readings vary throughtout the day and determine whether, for example, the readings are consistently lower at the start, middle, or end of the day.

Sorry for my delayed response.

12/22/23	11:24 AM	122	77	84	Elevated
12/21/23	9:40 PM	138	85	85	Stage 1
12/21/23	1:48 PM	109	73	88	Normal
12/21/23	9:27 AM	118	81	83	Stage 1
12/21/23	7:10 AM	150	87	72	Stage 2
12/20/23	9:31 PM	120	75	80	Elevated
12/20/23	2:43 PM	94	70	85	Normal
12/20/23	1:19 PM	87	70	84	Normal
12/20/23	9:21 AM	109	72	90	Normal
12/20/23	8:36 AM	123	82	82	Stage 1
12/20/23	8:32 AM	135	90	74	Stage 2
12/20/23	8:31 AM	122	77	76	Elevated
12/19/23	9:49 PM	162	87	70	Stage 2
12/19/23	9:52 AM	174	102	65	Stage 2
12/18/23	8:31 PM	164	96	72	Stage 2
12/18/23	2:26 PM	163	95	70	Stage 2
12/18/23	11:04 AM	173	96	68	Stage 2
12/15/23	9:26 PM	188	104	66	Crisis
12/15/23	7:28 AM	170	93	61	Stage 2
12/14/23	12:07 PM	179	109	55	Stage 2
12/14/23	11:32 AM	178	104	56	Stage 2
12/14/23	11:27 AM	178	96	57	Stage 2
12/13/23	12:56 PM	161	90	62	Stage 2