Highlight range of column cells in color, based on date on another cell

[KSKWin]

Hi,

I have an Excel with Column as Date, Day and other Text columns. Based on date (say current date) the range of columns should be highlighted in color.


Thanks
Kskwin

 

[Georgiboy]

Maybe with conditional formatting:

Book1
	A	B	C	D
1	Date	Num 1	Num 2	Num 3
2	23/06/2023	37	60	2
3	24/06/2023	46	69	64
4	25/06/2023	88	68	9
5	26/06/2023	38	43	25
6	27/06/2023	55	22	100
7	28/06/2023	1	66	34
8	29/06/2023	2	48	8
9	30/06/2023	61	78	17
10	01/07/2023	34	8	74
11	02/07/2023	94	4	65
12	03/07/2023	10	87	99
13	04/07/2023	7	75	40
14	05/07/2023	10	87	71
15	06/07/2023	66	9	18
16	07/07/2023	48	11	4
17	08/07/2023	83	89	13
18	09/07/2023	4	73	100
19	10/07/2023	66	28	68
20	11/07/2023	24	42	60
21	12/07/2023	60	4	42
22	13/07/2023	22	5	56
23	14/07/2023	88	31	36
24	15/07/2023	100	15	47
Sheet2

Cell Formulas
Range	Formula
B2:D24	B2	=RANDARRAY(23,3,1,100,TRUE)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D24	Expression	=$A2=TODAY()	text	NO

 

[KSKWin]

Maybe with conditional formatting:

Book1
	A	B	C	D
1	Date	Num 1	Num 2	Num 3
2	23/06/2023	37	60	2
3	24/06/2023	46	69	64
4	25/06/2023	88	68	9
5	26/06/2023	38	43	25
6	27/06/2023	55	22	100
7	28/06/2023	1	66	34
8	29/06/2023	2	48	8
9	30/06/2023	61	78	17
10	01/07/2023	34	8	74
11	02/07/2023	94	4	65
12	03/07/2023	10	87	99
13	04/07/2023	7	75	40
14	05/07/2023	10	87	71
15	06/07/2023	66	9	18
16	07/07/2023	48	11	4
17	08/07/2023	83	89	13
18	09/07/2023	4	73	100
19	10/07/2023	66	28	68
20	11/07/2023	24	42	60
21	12/07/2023	60	4	42
22	13/07/2023	22	5	56
23	14/07/2023	88	31	36
24	15/07/2023	100	15	47
Sheet2

Cell Formulas
Range	Formula
B2:D24	B2	=RANDARRAY(23,3,1,100,TRUE)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D24	Expression	=$A2=TODAY()	text	NO

Thank you very much. Awesome.

 

[Peter_SSs]

Thank you very much. Awesome.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.