|
TIP: Useful use of colour scales in Excel 2007
Please Register to Remove these Ads
After just finishing typing in 12 pricelists (W x H) of 15 x 11 items I thought of using colour scales to verify the input, sure enough most of my mistypes where highlighted!
It wont catch all errors but quickly points out 52.10 insted of 152.10 and 123.43 instead of 213.43 etc! Which in this case would have been most of the errors!
You only have to highlight the list data and select conditional formatting/colorscales the auto preview will show you without making it permanent!
__________________
 No longer looking for work (still if you want to pay me lots of money lets talk!!!)
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare............
Now, thanks to the Internet, we know this is not true.
Robert Wilenski (since there is some confusion I am not Robert he wrote the quote!)
|
Linear Mode
