Forum Discussion
Formatting a table based on todays date
Select all data rows of the table. The active cell in the selection should be in the first data row.
In the following, I'll assume that the first data row is row 2, and that the relevant date column is column D.
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=$D2=TODAY()
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.To receive an email with eligible employees would require VBA.
Select all data rows of the table. The active cell in the selection should be in the first data row.
In the following, I'll assume that the first data row is row 2, and that the relevant date column is column D.
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
=$D2=TODAY()
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
To receive an email with eligible employees would require VBA.