Conditional Formatting and Subtotals
I have an invoice database and use subtotals from the Tools Menu to calculate
total, average and count, grouped by company. I want to use colour to make
the different types of calculation stand out. So, for example, colour the
totals one colour, the averages another colour and the counts yet another
colour. Ideally I would like to be able to colour both the text in the cells
which contain, for example €śCompany X Total€ť and the actual figure in the
corresponding cell.
Any ideas?
|