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.

[TABLE="width: 101"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 101"]
<colgroup><col></colgroup><tbody>[TR]
[TD][TABLE="width: 296"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]19/07/2019[/TD]
[TD]Within warranty[/TD]
[/TR]
[TR]
[TD]30/11/2018[/TD]
[TD]Highlighted cell warranty ended[/TD]
[/TR]
[TR]
[TD]16/06/2019[/TD]
[TD]Within warranty[/TD]
[/TR]
[TR]
[TD]19/07/2019[/TD]
[TD]Within warranty[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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