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