Automatic Highlight After Certain Date

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.

Date RaisedFollow Up Required
12/11/2017Yes
30/11/2017Yes
26/11/2017No

<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>
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
4,009
.

A
B
C
D
E
F
G
1
Date RaisedFollow Up Required
2
10/27/2017
Yes
3
30/11/2017Yes
4
26/11/2017No
5
6
Conditional Formatting
7
New Rule
8
Use a formula to determine which cells to format
9
In B2
10
=TODAY()>A2+30
11
Select FILL color
12
13
Repeat above with :
14
=TODAY()>A2+14
15
16
Repeat again with :
17
="No"
18
Select FILL color

<tbody>
</tbody>
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,129,806
Messages
5,638,475
Members
417,026
Latest member
UDK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top