Date with CF

F

FC

I' like to find a formula to do conditinal formating for cells with no colors
containing dates to turn green when is 6 month before a due date ( with a
reference date), and red when is 3 month before.
Also in different sheet I need a formula that gives me the date of 9 months
ahead of a reference date in another cell. Thank you very much.
 
T

Tevuna

If Due date is in cell A1, enter this formula in the box where Excel allows
you to enter your own formula.
=A1>EDATE(A1,-6)
Format = Green

=A1>EDATE(A1,-3)
Format = Red
 
T

Tevuna

Same with the second question:
If reference date is in cell A1
=EDATE(A1,9)
Format as date
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CF for next month/this year 6
Conditional formatting dates 3
Cobditional Formatting Rows based on dates in action plan. 0
Conditional Formatting in Excel 2003 2
"If" function and Upcoming Dates 1
Using CF to change colour in cell based on date? 4
Colour Coding dates 6
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3

Top