Macros

Hi Nicola

Thanks for the post - sorry for our late reply

This can be done very simply what you need to is start recording a macro make sure that you click the relative reference button on the recording macro toolbar

Then go to the format menu and select cell - go to the pattern tab then choose the colour for the cell - select OK
when you are finish doing that stop recording the macro and thats it

To run the macro on other cells go to the tools menu - macro then click the macro and click RUN

this should do the trick

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn