I'm sure this will have been answered before but I can't find it. How do you conditionally format a cell containing dates to change colour if it's more than a specific amount of day's in the past.Thanks for the help.Jim
the 'if' function should solve this for you.johnny.
Something like=IF (TODAY() - A1) > 3
Format>Conditional formattingCell value is "Less than" and the amount box put=TODAY()-B1where B1 is a cell that contains the number of days ago you want. You can, of course, enter this number directly, instead of via a cell.Regards,Simsy
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.