Formula Cell Color depending on Date

[balvy]

Hello everybody,

I have this Excel document i use at work, i have a cell with today's date (B4) on it and a table where i have a agenda like with the dates (AC2, AD2.. and so on) what i need is that if the cell (B4) is equal to today's date in the agenda(AC2 or AD2 or so on) it changes the cell color in the agenda.

19/11/2014 (B4)
projects	19/11/2014 (AC2)	20/11/2014 (AD2)	21/11/2014 (AE2)
project #1	to do list	to do list	to do list

<tbody>
</tbody>

so using that table AC2 should change colors today and tomorrow AD2 Should be a different color and AC2 should be back to normal.
i'm not even sure this is possible but it would really help me finding the date I'm working on. I am willing to use VBA if necessary

Best Regards,

 

[JoeMo]

You can use Conditional Formatting.

1. Select AC2:AE2 with your mouse.
2. Home>Conditional Formatting>New Rule>Use a formula
3. Formula is: =AC$2=$B$4
4. Choose format
5. Click OK