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.
I have columns A-T. The dates I am looking for will be in columns $F2-207 all the way to T2-207.
I created a simple formula that gives me a date 6 months from the previous date. The original date was the employee's start date. From the start date it goes every six months.
Do you want to highlight a row if any of the dates in columns F to T equals the current date? If so, use the steps in my previous reply, but with formula
=OR($F2:$T2=TODAY())