Hi everybody,

I've got an Excel workbook that has conditional formatting (formula is
linked to value in another cell). There are about 100 cells involved on 10
sheets.

What I would like to be able to do is to save that formatting as the cell
format i.e. just keep the colour to highlight the cell.

Once the formatting is saved I would then like to be able to re-use the
conditional formatting function (same criteria, different colour).

The workbook is used for self evaluation and what the end user would like is
to be able to see last year's marks and this year's - if it helps to know
that.

If anyone could help, that would be brilliant!

Thank you

Diddy