Conditional Format on Expiration Dates 365 Days in Future

[SGT Singleton]

Hello!
So I have a question, I have to input training certificates for soldiers into excel. I would like them to automatically change color 365 days after the date I have entered. I have been trying to find help but every forum or help I have found uses "TODAY" or "NOW" feature which doesn't help me. Basically I need to be able to type the date+365 and have it change red.
I would like the formula to be a date and the text to be "GO" in color green when the certificate is valid, but after 365 days from that specific date, to change to red and say "NO GO" Is this possible? Can anyone please help me?
Reference link:
https://www.techonthenet.com/excel/questions/cond_format4_2007.php

Thanks a bunches!
SGT S

 

[Logit]

Let's say your date is in F2. You will need to use G2 as the display for the "GO", "NO GO".

First, to get the GO / NO GO to appear, click on G2 and enter this formula:

=IF(F2+365>NOW(),"GO","NO GO") then press ENTER.

For the color formatting: click on G2 then go to FORMATTING / NEW RULE / Use a formula to determine which cells to format. Two formatting formulas in G2:

Expired:
=$F2+365<TODAY() Fill: Red Font: Bold / White

Valid:
=$F2+365>TODAY() Fill: Green Font: Bold / White

 

[GraH - Guido]

alternative: just 2 Conditional formatting rules

EDIT: not awake yet . Just use (C3+365) >TODAY (), but the rest is ok.

1. =WORKDAY.INTL(C3,365,"0000000",)>TODAY()
   • Green font
   • custom number format "Go"
2. =WORKDAY.INTL(C3,365,"0000000",)<=TODAY()
   • red font
   • custom format "No Go"