Formula Cell Color depending on Date

balvy

New Member
Joined
Nov 14, 2013
Messages
11
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)
projects19/11/2014
(AC2)
20/11/2014
(AD2)
21/11/2014
(AE2)
project #1to do listto do listto 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,
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
16,849
Office Version
2010
Platform
Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,525
Messages
5,469,171
Members
406,641
Latest member
snyderman

This Week's Hot Topics

Top