Copy & Paste conditional formatting

[happydonut]

Hello,

Could someone help me out here?

I have a sheet with the week number in A1 followed by the dates for that week (starting Monday) in B1 to Friday in F1. Each date has 4 cells with value below (i.e. in cells B2 to B5).
I also have the next week number starting in A10, followed by the dates for that week in B10 to F10... and so on.

Furthermore, I have today's date in cell J1, =TODAY()

What I want to do is, if the date in, for instance B1 is equal to todays date (J1), then the cells below B1 (B2 to B5) should have a background color.
I know how to do this (I did put a conditional formating for B2-B5 with a new rule using the 'Use a formula to determine which cells to format' - where I used if B1=J1.

My question is, can I copy and paste this conditional formatting, so that for each date, when it equals todays date, the cells below that date will be formatted as above?
Or do I need to put a new rule for each date?

 

[EFANYoutube]

Issue you will have is that the formatting will be correct for B11 but once you copy the formatting down, it will look at B11=J1 instead of B10=J1
I would have your dates in a hidden column on the right somewhere and reference that instead on B10, then the following would work

G2=$J$1

 

[happydonut]

Issue you will have is that the formatting will be correct for B11 but once you copy the formatting down, it will look at B11=J1 instead of B10=J1
I would have your dates in a hidden column on the right somewhere and reference that instead on B10, then the following would work

G2=$J$1

Sorry but I'm not following?

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	26	28/06/2021	29/06/2021	30/06/2021	01/07/2021	02/07/2021				07/07/2021
2
3
4
5
6
7
8
9
10	27	05/07/2021	06/07/2021	07/07/2021	08/07/2021	09/07/2021
11
12
13
14
15
16
17
18
19
20	28	12/07/2021	13/07/2021	14/07/2021	15/07/2021	16/07/2021
21
22
23
24
25
Main

Cell Formulas
Range	Formula
J1	J1	=TODAY()

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F5,B11:F15,B21:F25	Expression	=INDEX(B:B,INT((ROW()-1)/10)*10+(ROW()<10))=$J$1	text	NO

 

[EFANYoutube]

what happens if you do the below for B2-B5 and then copy paste the formatting accross the rest?

B2=$J$1