I have a spreadsheet where we track field visits. We update this form weekly with visits and send it to someone who keeps track of everyone's visits. We add visits each week and what we do is we change the font color for the new visits to red, previously reported visits are sent in black. I would like to automate the color changing for the new visits as sometimes people forget to change the color or miss a line. I have a fuction to get the last file save date:
That gives me the date using =lsdate() in a cell. Is there a way to do have the new entries colored red and the old entries change to black? I appreciate any feedback.
Code:
Function LSDate()
LSDate = Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Last Save Time").Value
End Function
That gives me the date using =lsdate() in a cell. Is there a way to do have the new entries colored red and the old entries change to black? I appreciate any feedback.