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
Bookmarks