QuickTopic (SM) free message boards QuickTopic (SM) free message boards
Skip to Messages
  Sign In to access your topic list  |New Topic |My Topics|Profile
Upgrade to Pro   Customize, show pictures, add an intro, and more:   QuickTopic Pro...and check out QuickThreadSM
Topic: Help with Excel functions (www.meadinkent.co.uk)
Views: 26724, Unique: 8439 
Subscribers: 59
What's
this?
Printer-Friendly Page
Subscribe to get & post, or stop messages by email Subscribe
   << 2275-2283  2274-2274 of 2283  2258-2273 >>
About these ads
Who | When
Messagessort recent-top   
Post a new message
 
deltreg  2274
06-11-2009 04:44 PM BST
Ray
You can identify changes when updating your spreadsheet by using conditional formatting. If you have a column/row with last weeks figures in and a column with this weeks figures in. Then choose this weeks cell, choose Format, Conditional formatting, choose Cell value is, not equal to,type last weeks cell ref. and in Format choose patterns and choose a colour. Copy formatting to other cells. These cells will automatically colour when value is different. As for email, pass.
RSS link What's this?
   << 2275-2283  2274-2274 of 2283  2258-2273 >>
QuickTopicSM message boards
Over 200,000 topics served
Learn more Frequently asked questions  Acknowledgements
What they're saying about QuickTopic
 Questions, comments, or suggestions? Contact Us
Read our use policy before beginning. We value your privacy; please read our privacy statement.
Copyright ©1999-2008 Internicity Inc. All rights reserved.