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.
iMac Pro review
The City of Los Angeles graphic designer job ad amuses internet
Les meilleurs smartphones Android (2018)
© Copyright 2018 IDG UK. All Rights Reserved.