A
Alan Olrog
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.
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.