Date if function

[ridwanr]

Hi all,

Am looking for a formula in which if the date is = or > than 6 month then the date should be highlight in green colors.

On contrast to it if its < than 6 month then it should be in red.

Pls see attached example for better understanding.

Thanking you for your help in advance.

Regards,
Ridwan

 

[herofox]

You can to Use This Formula In Condition Formating

=DATEDIF(A2,TODAY(),"M")<=6

 

[herofox]

Why did you delay responding to all this?
You can try to make it by YourSelf , by this

=DATEDIF(A2,TODAY(),"M")>6