Conditional Formatting on Cell that is outside the 365 days warranty end date

[gplans]

I am trying to set some conditional formatting on cell that are outside the 365 days warranty end date that is entered into the cell.

19/07/2019 Within warranty 30/11/2018 Highlighted cell warranty ended 16/06/2019 Within warranty 19/07/2019 Within warranty <colgroup><col><col></colgroup><tbody> </tbody> <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

Cant seem to find anything that matches my criteria. Any help thanks.

 

[gplans]

No, it was formula in CF rules: =IF(#REF!="","",DATEDIF(#REF!,TODAY(),"d")>7)

I'll look at CFs later

Ya I need that. If the issues has not been resolved within 7 days it will highlight another cell in the spreadsheet.

 

[sandy666]

try

[highlight][B][COLOR="#0000FF"][1][/COLOR][/B][/highlight] =IF(C3>TODAY(),0,ABS(TODAY()-C3)>=365)

after add another CF rule, move rule [highlight][1][/highlight] to the top

 

[gplans]

try

[highlight][B][COLOR=#0000FF][1][/COLOR][/B][/highlight] =IF(C3>TODAY(),0,ABS(TODAY()-C3)>=365)

after add another CF rule, move rule [highlight][1][/highlight] to the top

This still did not work. This formula produced the same results as the previous one.

 

[sandy666]

Picture is useless, all I can say is: Beautiful Picture!
Post excel file or formulas

 

[gplans]

Picture is useless, all I can say is: Beautiful Picture!
Post excel file or formulas

I got it to work.

<today()), "")="" which="" is="" the="" same="" as="" formula="" that="" you="" supplied="" earlier="" except=""><today()), "")
<today()), "")
<today()), "")
<today()), "")
<today(),'')<today()), "")

<today()), "")'

This is very close to the formula that you supplied earlier.

=R3>TODAY() except that > is now <

Thanks for all your help</today()),></today(),'')<today()),></today()),></today()),></today()),></today()),></today()),>

 

[sandy666]

You are welcome

Have a nice day