Conditional formating

T

Tazeem

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
 
T

Tazeem

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

Regards,
 
J

Joel

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
 
Top