Date - Conditional Formatting

[ashani]

Hi everyone,
I wonder if someone could please guide me.

In my spreadsheet Column C14 - when user input the future date i.e. 01/01/2021 - if it's less than 6 months than it should turn Red.

Please can you help me.

Thanks

 

[Ezguy4u]

Let's get the ball rolling. Now if you have any questions let us know. Conditional format is very confusing and not much fun.

=YEARFRAC(NOW(),C14)<0.5

Book1
	A	B	C
1
2
3
4
5
6
7
8
9
10
11
12
13
14			4/8/2021
Conditional

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C14	Expression	=YEARFRAC(NOW(),C14)<0.5	text	NO

 

[ashani]

Thank you

 

[Ezguy4u]

My pleasure.

 

[KevCarter]

Let's get the ball rolling. Now if you have any questions let us know. Conditional format is very confusing and not much fun.

=YEARFRAC(NOW(),C14)<0.5

Book1
	A	B	C
1
2
3
4
5
6
7
8
9
10
11
12
13
14			4/8/2021
Conditional

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C14	Expression	=YEARFRAC(NOW(),C14)<0.5	text	NO

Cool little formula! That's the first time I've seen YEARFRAC...

 

[Ezguy4u]

You know Kev, I always wonder how everybody else come up with a solution to a problem. In this case I just looked thru Date and Time functions and there it was. It's not like I even use the year fraction all that often. But once I saw it, I knew I had to experiment with it and see if it would work for this problem. And it did work.