View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
anne7134 anne7134 is offline
external usenet poster
 
Posts: 3
Default Create a formula to calculate when info. was last updated

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?