Does such a function exist

[kennedy]

Hello everyone,

I was curious to know if there is a way to put a formula into a cell such as when a person reaches 15months from a certain date the cell will turn a color such as red as a reminder. Any help would be great!

Thanks much,
Kennedy

[mudraker]

Use Conditional formatting which is under the Format Menu

[kennedy]

What value or formula would I use to get the 15 month difference from a set date?

[dominicb]

Good morning kennedy

Your question's a bit vague, so I can't give you an answer to your circumstances, but say you have a date in A1 and a date in B1, then set this up in C1 to change it's colour if it's within 15 months :

FormulaIs
=DATEDIF($A$1,$B$1,"m")<15

HTH

DominicB

[kennedy]

OK, so here is the whole story. I'm in the Navy and I have to make a default spreadsheet for different divisions onboard to use. My knowledge of spreadsheets isn't very good, I can do very basic things. There is a Column in the spreadsheet for each persons "PRD" (the date they are supposed to transfer, each person's if different) I need to find a way to make the cell turn red whenever their "PRD" is 15 months or less away from =NOW(). Let me know if you need more info, sometimes I don't put what I'm thinking into words very well.

[dominicb]

Hi kennedy

Say your PRD date is in cell A1 then this formula in Conditional Formatting will change the colour of the cell when it is within 15 months of today's date :
=DATEDIF($A$1,NOW(),"m")<15

HTH

DominicB