Auto formating

sax · Mar 19th, 2002, 07:13 AM

I have a sheet with data which I have to update manualy every day.
Is there any way (not VBA) to change the colour of the row every time I make a change to a data in that row.
At the end of entering data I would like to remove all colours from whole sheet.
Any suggestions ?
Thanks in advance

Russell · Mar 19th, 2002, 07:27 AM

Have you tried using Tools - Track Changes
You can accept them when you have finished editing

Dave Hawley · Mar 19th, 2002, 07:27 AM

Hi Sax

Take a look at Conditional Formatting under "Format"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 07:13 AM	#1
sax Board Regular Join Date: Feb 2002 Location: Belgrade, Yugoslavia Posts: 148	I have a sheet with data which I have to update manualy every day. Is there any way (not VBA) to change the colour of the row every time I make a change to a data in that row. At the end of entering data I would like to remove all colours from whole sheet. Any suggestions ? Thanks in advance

Mar 19th, 2002, 07:27 AM	#2
Russell New Member Join Date: Mar 2002 Posts: 39	Have you tried using Tools - Track Changes You can accept them when you have finished editing

Mar 19th, 2002, 07:27 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Sax Take a look at Conditional Formatting under "Format"