Link to home
Create AccountLog in
Avatar of agwalsh
agwalsh

asked on

Any quick way to copy conditional formatting to large amounts rather than Format Painter or Paste Special

hi
Just wanted to see if there is any other way (other than Paste Special or Format Painter) to quickly copy conditional formatting to a large number (6000 plus) cells without using code...
Avatar of Brendan M
Brendan M
Flag of Australia image
conditional formatting menu->manage rules
change 'show formatting rules for' to this workbook
change applies to to the range you want eg:A10:A30 or A10:D40 or A10:B20,A30:B40 for multiple ranges
Avatar of agwalsh
agwalsh

ASKER

OK - so let me get this. I have an area on a spreadsheet - let's say A1:D5 that has the formatting I want to copy.  Do I now select the area I want to copy the formatting to? and then go through these steps you've outlined below.  I've attached a file - at the moment CF is applied to C3:c12. I want to copy this formatting to the rest of the column.  How will I use your suggestion. Thanks.
CF--extend-range.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Brendan M
Brendan M
Flag of Australia image
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of agwalsh
agwalsh

ASKER

Yum, ah, that works beautifully - thank you for your clarification - much appreciated.
Avatar of Brendan M
Brendan M
Flag of Australia image
hey, glad to hear :) could you please accept the comment as the answer, thank you
Avatar of agwalsh
agwalsh

ASKER

Thanks for that. Sorry I didn't do it sooner - I thought I had marked it as the solution. Much appreciated.