Conditional Formatting- Dates

[erikamargaret]

This is for invoicing for a business.
I have a list of dates for when project invoices get sent out to clients, and I would like to keep track of how long they are out before payment is received from the client. I want the number to be accurate to today's date, but when payment is received, that date is entered in a third column and the "rolling" number in the second column stops (and is possibly highlighted green?). If "rolling" number of days exceeds 30, I would like the cell to be highlighted yellow, if it exceeds 45 days I would like it highlighted red. Is this possible??

Example (using today's date):

Invoice date	Days out	Payment received
13-Nov	14
10-Nov	15	25-Nov
25-Oct	33
03-Oct	55

<tbody>
</tbody>

 

[Special-K99]

Try
3 formulas required, in this order

Green:
=(NOT(ISBLANK(C1)) (Tick Stop if True box)

Red:
=(TODAY()-A1 > 45) (Tick Stop if True box)

Yellow:
=(TODAY()-A1 > 30)

 

[erikamargaret]

Sorry, but I'm more of a basic Excel user...could you elaborate a bit on these instructions? What's tick stop if true box??

 

[Special-K99]

Select the top date in your B column B2 presumably
Select Conditional Formatting from the ribbon (top of screen)
Manage Rules
New Rule
Use a Formula to determine...
Enter the formula in the Format values where... dialog
Select the format you require for that formula
Click OK
Click OK again
The Conditional formulas that relate to this cell are listed
There is a box on the right Stop If True, tick if needed (see above)
Click OK once all three formulas are entered

Use Format Painter to paste to other cells

 

[erikamargaret]

This is so helpful, thank you so much for your help! I'm sure I'll be asking more questions in this forum as time goes on