Cable Forum - View Single Post

absthechatter · 26-05-2005, 10:09

Thanks for that.

What I am doing is sending out a spreadsheet to several thousand sites. The spreasheet consists of about 10 worksheets with about 20 columns in each. Most of the information is filtered and chosen from a picklist. There will be 10 different people quality assuring the information that comes back. They only have a short time to do it and what I wanted was for them to be able to see at a glance, any information that had been changed - possibly by highlighting it in a different colour. I wanted to avoid additional columns if possible.
I know I can use conditional formatting to change the colour and I could use the "equal to" to show if each cell has been changed. But can I put some formula in to show something like "equal to whatever the contents of cell are" so I don't have to individually put the formatting in each cell?

Many thanks

Abs

26-05-2005, 10:09	#3
absthechatter Inactive Join Date: Dec 2004 Posts: 310	Re: Microsoft Excel Help Needed Thanks for that. What I am doing is sending out a spreadsheet to several thousand sites. The spreasheet consists of about 10 worksheets with about 20 columns in each. Most of the information is filtered and chosen from a picklist. There will be 10 different people quality assuring the information that comes back. They only have a short time to do it and what I wanted was for them to be able to see at a glance, any information that had been changed - possibly by highlighting it in a different colour. I wanted to avoid additional columns if possible. I know I can use conditional formatting to change the colour and I could use the "equal to" to show if each cell has been changed. But can I put some formula in to show something like "equal to whatever the contents of cell are" so I don't have to individually put the formatting in each cell? Many thanks Abs