Thanks for your reply Leo.
I know that I can copy formats the way you describe - I was trying to avoid
having to re-format the 400+ rows afterwards, which would involve re-applying
styles and borders.

I was hoping for a way of copying just the conditional formatting. Or, if I
Autofilter first by Style, to copy formatting to the filtered (visible) rows
without applying it to the hidden rows.
I seem to remember seeing something about the 'visible' rows when using
filters, but can't recall the details.
Thanks anyway. Your method may well be the quickest in the end.
Alan Olrog

"Leo Rod" wrote:

Edit - Copy -then Edit - Paste Special - Formats

This will copy all formats, including conditionals, then you can reformat
any cell borders-colors or others that you did not wanted to be copied, if
any.

Let me know how it worked.

Leo Rod
Mia, Fl, USA


"Alan Olrog" wrote in message
...
Hi. I'm using Excel 2002 SP3.

Can I copy just the Conditional Formatting of a cell without copying other
formatting?
Failing that, can I copy the whole formatting of a cell to the rest of a
filtered column without affecting the hidden cells?

I have 400+ rows, columns A-Z, and each row has one of five styles applied
which sets the font colour.
Based on the text string in column AB I want to apply conditional
formatting
to columns A-Z of the row which will set just the shading of the cell.
I can successfully set up the conditional formatting (CF); the problem is
in
propagating it to other rows.

For example, if I start with cell A1 and CF 'Formula Is' =($AB1="Not yet
in
use") that works fine.
I'd then like to copy the CF down column A and automatically change the
formula to $AB2, $AB3 etc. However if I use Paste Special to 'Fill
Formatting
Only' it also changes the style of each cell to A1's style.

How can I easily copy the CF down Column A without altering other
formatting?

As an alternative method, I can apply an Autofilter to select rows of one
style, but Paste Special then applies formatting to the hidden cells which
is
no help. Strangely, using plain handle-drag Autofill on an Autofiltered
column only affects the visible rows, but of course, this copies values
too.

Any suggestions appreciated. I'm happy to give VBA a try.