Conditional formatting based on a Week commencing date

[Paul JS]

Hello all

Continuing on with my conditional formatting I have another question... this tie I have attached an example sheet.

I have data entered on a weekly basis. It's always in arrears so on 23 August I will be entering data for week beginning 16 August. I have some cells reading from another sheet but for the example I have created a small grid with some numbers in it. As the example shows, what I would like is the greyed numbers in line with 16 Aug to go black when we hit 23 August. On 30 August I would like the numbers to go black on the line for 23 August.

Hope that makes sense. I know you guys won't fail me.

I won't be back on until Monday now so hope you have a great weekend.

regards

[etaf]

Try
=AND($B2<=TODAY(), B2<>"")

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
C2:E100, however many rows you need

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($B2<=TODAY(), B2<>"")

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

[kvsrinivasamurthy]

Select C2:E5. CF formulas
For black

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

for Grey

=AND($B2<>"",$B2>=TODAY())

[Paul JS]

Thank you both. I have added the formats and am going to wait until Monday to confirm it does what I need. Appreciate your help and sorry for the delay in gettin g back on here.

Regards