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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]19/11/2014 (B4)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]projects[/TD]
[TD]19/11/2014
(AC2)[/TD]
[TD]20/11/2014
(AD2)[/TD]
[TD]21/11/2014
(AE2)[/TD]
[/TR]
[TR]
[TD]project #1[/TD]
[TD]to do list[/TD]
[TD]to do list[/TD]
[TD]to do list[/TD]
[/TR]
</tbody>[/TABLE]

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