Forum Discussion
Automatically highlight the current week
Hi all, I am trying to complete a table and I want to have the current week commencing date to automatically highlight a colour. I have tried conditional formatting to no avail.. any suggestions
very basic look just to get the formula idea
Select B2:BB10 (or further down if you wish).
B2 should be the active cell in the selection.On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=TODAY()-WEEKDAY(TODAY(), 3)=B$2
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Select B2:BB10 (or further down if you wish).
B2 should be the active cell in the selection.On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=TODAY()-WEEKDAY(TODAY(), 3)=B$2
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.Thank you so much, worked a charm :)
