Conditional formating
 

Hi every one,

I want that upon entering new data (numbers + text) or changing previous
values of a sheet the color of cells should be changed. Is it possible?

Thanks in advance

Conditional formating
 

With excel 2003 you can turn on Tools - Track Changes

"Tazeem" wrote:

Hi every one,

I want that upon entering new data (numbers + text) or changing previous
values of a sheet the color of cells should be changed. Is it possible?

Thanks in advance

Conditional formating
 

Thanks a lot Joel. However, is it possible so through conditional formatting?.

Regards,

"Joel" wrote:

With excel 2003 you can turn on Tools - Track Changes

"Tazeem" wrote:

Hi every one,

I want that upon entering new data (numbers + text) or changing previous
values of a sheet the color of cells should be changed. Is it possible?

Thanks in advance

Conditional formating
 

For conditional to work, you would need to make a copy of the worksheet to
use as a master. Then compare the Master sheet against the current sheet to
track changes. But conditional formating doesn't work across multiple
worksheets.



A1<Master!A1

"Tazeem" wrote:

Thanks a lot Joel. However, is it possible so through conditional formatting?.

Regards,

"Joel" wrote:

With excel 2003 you can turn on Tools - Track Changes

"Tazeem" wrote:

Hi every one,

I want that upon entering new data (numbers + text) or changing previous
values of a sheet the color of cells should be changed. Is it possible?

Thanks in advance