Conditional Formatting with Dates and Number

[ChetanPuri]

Hello Excel Gurus,

Just need some help with conditional formatting. I have a spreadsheet with column headers with weekly dates for example 07 July 2023, 14 July 2023 up until 24 June 2024. Underneath the Dates headers I have data in form of numbers. And my recent reporting date was 09 Feb 2024. I want To create a conditional formatting that any date higher then the reporting date and the Data on those dates should get highlighted with colour. Any recommendations or help would be much appreciated.

Many thanks,
Regards
Chetan

 

[awoohaw]

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Reporting Date:	2024-02-09
2		2023-07-07	2023-07-14	2023-07-21	2023-07-28	2023-08-04	2024-02-02	2024-02-09	2024-02-16	2024-02-23	2024-03-01	2024-03-08	2024-03-15
3		4	1	1	3	1	3	1	1	5	4	4	2
4		1	4	1	2	2	3	3	3	1	1	1	5
5		5	4	2	3	1	2	1	1	4	4	1	2
6		1	5	5	1	3	3	4	4	4	2	2	3
7		5	3	3	5	5	4	3	2	3	2	4	2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:M7	Expression	=B$2>$B$1	text	NO

 

[ChetanPuri]

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Reporting Date:	2024-02-09
2		2023-07-07	2023-07-14	2023-07-21	2023-07-28	2023-08-04	2024-02-02	2024-02-09	2024-02-16	2024-02-23	2024-03-01	2024-03-08	2024-03-15
3		4	1	1	3	1	3	1	1	5	4	4	2
4		1	4	1	2	2	3	3	3	1	1	1	5
5		5	4	2	3	1	2	1	1	4	4	1	2
6		1	5	5	1	3	3	4	4	4	2	2	3
7		5	3	3	5	5	4	3	2	3	2	4	2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:M7	Expression	=B$2>$B$1	text	NO

Thank you for your response, i followed the instructions , please see screenshot below , when I select and apply & confirm, it still doesn't work

 

[awoohaw]

You have the first cell reference as absolute, it should be partial.
Try

=L$10>$B$3

.


I suggest you watch this video on the MyOnlineTrainingHub You Tube channel:
This really made it easy for me: