Excel Help

[xxll_martin_llxx]

Hello,

Been busy working throughout the summer hence my lack of activity as I started picking up on here

I'm making a wage sheet for my two jobs to make sure I get paid the right amount for the hours I do.

What I'm wanting to know is I have it set up like this:


Waitrose £money amount here
Johnsons £money amount here

I'm wondering, with that formatting (I have used cells on there own for that above) is it possible to carry that over to another cell so that it would have the same formatting? (without going through manually and changing the fill colour of the cell).

Cheers, I hope that I've explained clearly enough. If not I'll get you some screenshots to go further with explaining.

Thank you.

[Hawky]

You could do the drag thing and copy the entire cell, including formatting and value into another cell, but you want it to only copy the formatting right? Not the value as well.

Here is a link to another workaround you may wish to try: http://excel.tips.net/Pages/T002769_...ormatting.html