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!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
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.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks