how to make a formula in excel

[sweisberg]

Hi I am trying to figure out what formula i would need if B2 is the main date (for example 7/1/2023), i would like:
- B3 to turn green if today is equal or greater than 3 months from B2 and red if it is less than 3 months away from B2
- then C3 to turn green 4 weeks after a date is inputed in B3

Let me know if this is possible

 

[SanjayGMusafir]

I suppose you are looking for Conditional formatting rules

B3 to turn green if today is equal or greater than 3 months from B2

=B3>B2+90

red if it is less than 3 months away from B2

=B3<B2+90

C3 to turn green 4 weeks after a date is inputed in B3

=Today()>B3+28

 

[MARK858]

Conditional formatting rules for B3

B3 to turn green if today is equal or greater than 3 months from B2

=TODAY()>=EDATE(B2,3)

red if today is less than 3 months away from B2

=TODAY()<EDATE(B2,3)