Capture conditional format as cell format

[Diddy]

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

 

[Jim Thomlinson]

Conditional formatting only exists as a virtual format. There is no easy way
to capture it. This might be one of those cases where instead of using
conditional formats you could use a macro to set your formats. Bare in mind
that that is a fair bit of custom code to write.

 

[Diddy]

Thanks Jim,

The cells with conditional formatting are directly above the cells whose
value informs the conditional format.

Could you give me a pointer as to how to go about coding, or should I repost
in programming? I've only dabbled so not sure what I need to do.

Thanks again
Diddy