CONDITIONAL FORMAT

[Guest]

I have a cell with a conditional format that i need to copy into a number of
other cells. Copy Paste special doesn't work, is there any other way rather
than to just key into evey cell manually.

 

[Shay]

I have a cell with a conditional format that i need to copy into a number of
other cells. Copy Paste special doesn't work, is there any other way rather
than to just key into evey cell manually.

Highlight all the cells you want to format, goto Format, Conditional
Format and apply.

Or am I missing something here?

 

[Roger Govier]

Hi Marshall

You say Copy>Paste Special doesn't work.
What is th formula in your conditional format?
What is the cell it is located in?
What is the range to which you want it applied?

You could use the Format Painter on the toolbar, but if Paste Special
doesn't work, then this probably won't work either, which is why I am
asking these questions.

Regards

Roger Govier

 

[Guest]

Many thanks Shay. You've sorted in minutes wot we couldn't do in hours.

 

[Guest]

Hi Roger,

Highlight all the cells you want to format, goto Format, Conditional
Format and apply.

This is the answer from shay that worked fine. Many thanks for your offer as
well.