Create a formula to calculate when info. was last updated
I hate to reply to my own post, but I went ahead and set it up with track
changes, and although it's not exactly what they wanted, I actually think it
may be more useful! I'd still like to add in the status update column, so if
you have an idea, that would be great, but this is good.
Thanks so much.
"anne7134" wrote:
Hello Dreid,
I wish it was, but the request is that I have a status column for each row
that would change depending on the last update to that row. I assumed that I
could use some sort of conditional formatting to note an update (maybe the
status column could turn red if the row was updated on the last save), but I
don't know how to create a cell/macro/formula that I can run the conditional
formatting off of.
Thanks so much,
Anne
"Dreid" wrote:
Hi Anne
Is "Tools" " Track Changes" an alternative ?
"anne7134" wrote:
Hi all:
I'm not sure if this is the appropriate forum, but I'd creating a file that
includes multiple lines and I'd like a cell for each line to act as a status
cell and note the last update to that line. Is there a way to do that?
|