Conditional Formatting: between difference of 2 dates

[yamzilla]

Hello!

I am trying to write a conditional format where if the difference between the dates (H2-G2) is:

1. <=180 days, the date in the G column turns green
2. >180 days, the date in the G column turns red

I don't want the "I" column, I was only using that column to help check/compare with whatever formula I was trying.

I appreciate any help I can get! I've read so many threads and watched enough YouTube videos to go cross-eyed.

 

[SanjayGMusafir]

<=180 days, the date in the G column turns green

Use formula to Conditional Format column G

=H1-G1<=180

>180 days, the date in the G column turns red

Use this -

=H1-G1>180

 

[yamzilla]

Thanks, that finally helped. I had to add: =AND(H1-G1>1, H1-G1<=180) in order for the blank spaces not to be colored green as well. Appreciate you!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.

 

[SanjayGMusafir]

in order for the blank spaces not to be colored green as well

for this you can try -

• Either H1 or G1 is Not Blank (as per your need)

=And(H1-G1<=180,OR(H1<>"",G1<>""))