Highlight entire row if date in cell is longer than 3 months

[Lmaonade]

Hi guys,

I'm trying to work out a way for an entire row to automatically highlight if a cell containing a date is longer than 3 months ago.

Here is part of my table:

I'd like the whole of cell A9 to N9 to highlight in yellow for instance if the Contract start date is longer than 3 months ago.

I tried this by highlighting A9 to N9, creating a conditional format for a formula: "= G9 < TODAY () - 90"<today()-90"<today()-90 with="" a="" fill="" option,="" now="" for="" some="" reason="" all="" of="" those="" cells="" highlighted="" yellow="" apart="" from="" cell="" b9?="" which="" was="" strange="" anyway,="" but="" then="" when="" i="" changed="" the="" date="" in="" g9="" to="" within="" last="" 3="" months="" it="" only="" unhighlighted="" a9.="" so="" even="" though="" 90="" days="" (which="" would="" mean="" want="" nothing="" that="" row)="" a9="" and="" b9="" were="" not="" rest="" stayed="" yellow.
<today()-90


I guess I am doing something wrong...

Any help would be appreciated.

Thanks,
Andy</today()-90
</today()-90"<today()-90>

 

[Lmaonade]

I don't think the picture is showing up right.

Maybe this will work.

<a href="https://ibb.co/hXw6Sx"><img src="https://thumb.ibb.co/hXw6Sx/Capture111.jpg" alt="Capture111" border="0"></a>

 

[Joe4]

I tried this by highlighting A9 to N9, creating a conditional format for a formula: "= G9 < TODAY () - 90"<today()-90"<today()-90 with="" a="" fill="" option,="" now="" for="" some="" reason="" all="" of="" those="" cells="" highlighted="" yellow="" apart="" from="" cell="" b9?="" which="" was="" strange="" anyway,="" but="" then="" when="" i="" changed="" the="" date="" in="" g9="" to="" within="" last="" 3="" months="" it="" unhighlighted="" a9.="" so="" even="" though="" 90="" days="" (which="" would="" mean="" want="" nothing="" that="" row)="" a9="" and="" b9="" were="" not="" rest="" stayed="" yellow.
</today()-90"<today()-90>

You need to use an ABSOLUTE reference on the column part of the formula, or else it will "float" as you move across cells A9:N9.
So your formula need to look like:
"= $G9 < TODAY () - 90"<today()-90"<today()-90 with="" a="" fill="" option,="" now="" for="" some="" reason="" all="" of="" those="" cells="" highlighted="" yellow="" apart="" from="" cell="" b9?="" which="" was="" strange="" anyway,="" but="" then="" when="" i="" changed="" the="" date="" in="" g9="" to="" within="" last="" 3="" months="" it="" unhighlighted="" a9.="" so="" even="" though="" 90="" days="" (which="" would="" mean="" want="" nothing="" that="" row)="" a9="" and="" b9="" were="" not="" rest="" stayed="" yellow.


See: http://www.excel-easy.com/functions/cell-references.html

</today()-90"<today()-90>