Quarantine Rooms

[MARKEGANDERSON]

Hello All,

I hope you can help with this.

So I have a room that is used for quarantine, as the employees return from R&R, they will need to go into quarantine for 14 days. After which the room will become available once again.
So the set up is Room, Employee name, check in date.
So I have all days labeled horizontally for each month, as the employees check in I want start the clock from that date(maybe highlight red for each quarantine days), then at the end of the 14 days, the highlight will be back to green.

Still trying to figure out how to approach this. Any Ideas would be helpful

 

[Fluff]

How about

+Fluff New.xlsm
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
3		01/09/2020	02/09/2020	03/09/2020	04/09/2020	05/09/2020	06/09/2020	07/09/2020	08/09/2020	09/09/2020	10/09/2020	11/09/2020	12/09/2020	13/09/2020	14/09/2020	15/09/2020	16/09/2020	17/09/2020
4	01/09/2020
5	05/09/2020
6
7
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F4:V7	Expression	=AND($E4>=F$3-13,$E4<=F$3)	text	NO

 

[MARKEGANDERSON]

Thank you sir, it worked like a charm

 

[Fluff]

You're welcome & thanks for the feedback.

 

[MARKEGANDERSON]

Hello Again Fluff
How would you highlight a range of cells based on the start/end date?
See attached

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1				01/09/2020	02/09/2020	03/09/2020	04/09/2020	05/09/2020	06/09/2020	07/09/2020	08/09/2020	09/09/2020	10/09/2020	11/09/2020	12/09/2020	13/09/2020	14/09/2020	15/09/2020	16/09/2020
2		04/09/2020	11/09/2020
3		06/09/2020	14/09/2020
4
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:S5	Expression	=AND($C2<>"",$B2<=D$1,$C2>=D$1)	text	NO

 

[MARKEGANDERSON]

Thanks Again Fluff, you make it look so easy!

 

[Fluff]

Glad to help & thanks for the feedback