Monthly Archives: September 2013

Relative and Absolute References

Posted on 7 September 2013 by spreadsheetexpertblog

One of the great attractions of spreadsheets when they started was their ability to quickly replicate complex calculations, once those calculations had been developed for one category. An example might be calculations worked out for one month , which could … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Conditional formatting – Hierarchy

Posted on 1 September 2013 by spreadsheetexpertblog

In 2003, the hierarchy is very important in Conditional Formatting: if you have that wrong some conditions may never be tested. Supposing you want the cell to go red if less than 50% in an exam, amber between 51 and … Continue reading →

Posted in Uncategorized | Leave a comment