FileDateTime() will return the date AND time of the last save of the file. Perhaps you want to return just the date? In which case, you'd need:
Then, let's say your date is in A1. Select A1 and add a new conditional format based on a formula of:![]()
Function LastSaveDateEx(Optional VolatileParameter As Variant) LastSaveDateEx = Int(FileDateTime("C:\Filepath\example workbook.xlsx")) End Function
Choose to highlight in red when the formula is true.![]()
=A1<>TODAY()
That should be enough.
WBD
Bookmarks