kimkent100
New Member
- Joined
- Nov 27, 2017
- Messages
- 1
Hi everyone,
Fairly new to Excel so apologies if this is a simple question!
I'm looking for a formula to highlight a cell based on the date within another cell e.g.
<tbody>
</tbody>
If the line has been 'open' two weeks over 'date raised' turn amber, 1 month red, no action required grey.
Hope you can help!
<tbody>
</tbody><colgroup><col><col></colgroup>
Fairly new to Excel so apologies if this is a simple question!
I'm looking for a formula to highlight a cell based on the date within another cell e.g.
Date Raised | Follow Up Required |
12/11/2017 | Yes |
30/11/2017 | Yes |
26/11/2017 | No |
<tbody>
</tbody>
If the line has been 'open' two weeks over 'date raised' turn amber, 1 month red, no action required grey.
Hope you can help!
<tbody>
</tbody><colgroup><col><col></colgroup>