Colour a Cell if an invoice is past date

Hi Guys
First post here
Im looking to colour a cell red if an invoice is past its due date of 91 days.
I was try to create if today>CELL+91 then red cell
But I just cant remember how to do it
ANy help would be great

Awesome

How do I make it reference the entire column

Conditional Formating

HI James

Just use the conditional formatting tool for this. Highlight your column Range with Invoice date, go to conditional formatting, enter a new rule & select use a formula to determine which cells to format.

next in the box for "format values where this formula is true" enter the below:

=if(today()>(CELL+91),1,0)

then click on Format, select the fill tab & choose your colour.

Regards
Mark