I have a spreadsheet which I use to keep track of monthly service accounts. When the date of the last payment is more than 20 days before today's date, I want to change the cell color to red.
Basically when DAYS360(B,TODAY())>20) I want to change the color of the cell to red.
Last edited by paulAPS; 08-27-2008 at 10:14 PM.
Dear PaulAPS,
Pls use conditional formating (home menu).
You choose the formula version and put your formula there, and choose the format you want.
Hoping this can help you,
YKnet
NB. Thanks for I learnt days360 formula from you.
Perfect, Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks