Conditional Formatting with date not working

[Dihusky]

I am trying to do away with column B on my spreadsheet by using conditional formatting to highlight column C. Currently I visually check the dates in column B to be prior to today to determine which budgets need to be actioned. I though I had the conditional formula right but nothing happens. Where am I going wrong? Once I get this right I will apply the principal to 5 more columns.

Copy of Dinah 2021.xlsx
	A	B	C	D
1	Building	Budget -7 days	Budget Date
2	16 CAREEL CLOSE	6/01/2021	13-Jan-21
3	35 BAYSWATER	10/02/2021	17-Feb-21
4	COLUMBIA TOWER
5	HATARI	25/03/2021	01-Apr-21
6	MERON WOODS
7	ROBINA LAKES MEDICAL CENTRE
8	SANTA FE BY THE BROADWATER	16/03/2021	23-Mar-21
9	SIGNATURE ON HIGH
10	TUDOR ROSE COURT
11	VARSITY PARK COURT	23/03/2021	30-Mar-21
12	26 CAREEL CLOSE	5/04/2021	12-Apr-21
13	68 STANHILL DRIVE
14	BIRDSONG
15	CORONATION GARDENS
16	DEE-ELL	20/04/2021	27-Apr-21
17
18
19
FYE (3)

Cell Formulas
Range	Formula
B2:B16	B2	=IF(C2>0,C2-7," ")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C:C	Expression	="$C2-7<TODAY()"	text	NO

 

[Peter_SSs]

Welcome to the MrExcel board!

You need to remove the quote marks from within the CF formula.
You may also want to add a test to exclude the blank cells so it may end up as

=AND($C2<>"",$C2-7<TODAY())

 

[Dihusky]

Welcome to the MrExcel board!

You need to remove the quote marks from within the CF formula.
You may also want to add a test to exclude the blank cells so it may end up as

=AND($C2<>"",$C2-7<TODAY())

Thank you - so simple

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.