Automatic Highlight After Certain Date

[kimkent100]

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

 

[Logit]

.

	A​	B​	C​	D​	E​	F​	G​
1​	Date Raised	Follow Up Required
2​	10/27/2017​	Yes
3​	30/11/2017	Yes
4​	26/11/2017	No
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>

​