Excel Learner

Hello.

 

I would like to use a conditional formula for dates, years and months while color assigning it based on what ifs. It is not working.

For example

Here is the original formula

=DATE(YEAR(J16),MONTH(J16)+8,DAY(J16))

I have it set up to turn green if this occurs.

Now if the months are less than 18 months I would like for the cell to turn yellow. How do I do this equation?

By: Vee

Leave a Reply

Your email address will not be published. Required fields are marked *