Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default track changes on an excel sheet

Hi All,

Can any one suggest me a way to highlight cells that have changed.
I use the excel RTD function which keeps changing the values in the cells on
a sheet.

So i would like to highlight these changed cells.

Is there any function in excel that could I use.

Any help would be highly appreciated..

Regards
Amar
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 142
Default track changes on an excel sheet

ToolsTrack Changes Highlight changes

"amar" wrote:

Hi All,

Can any one suggest me a way to highlight cells that have changed.
I use the excel RTD function which keeps changing the values in the cells on
a sheet.

So i would like to highlight these changed cells.

Is there any function in excel that could I use.

Any help would be highly appreciated..

Regards
Amar

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default track changes on an excel sheet

Hi,

Thanks for the post.
But

ToolsTrack Changes Highlight changes is for changes made by multip;e users.
It doesn't track changes that come from the RTD.

Amar



"ufo_pilot" wrote:

ToolsTrack Changes Highlight changes

"amar" wrote:

Hi All,

Can any one suggest me a way to highlight cells that have changed.
I use the excel RTD function which keeps changing the values in the cells on
a sheet.

So i would like to highlight these changed cells.

Is there any function in excel that could I use.

Any help would be highly appreciated..

Regards
Amar

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to hide/unhide sheet Tabs in Excel 2007? Smibes Excel Worksheet Functions 10 March 28th 07 02:45 AM
track changes on an excel sheet amar Excel Discussion (Misc queries) 0 November 8th 06 05:07 AM
can't paste in excel without having an open excel sheet! troy stud Excel Discussion (Misc queries) 3 October 27th 06 11:46 PM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 09:16 AM


All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"