Can I copy conditional formatting?
I have conditional formatting on some columns in my spreadsheet. I would
like to put that same formatting on some rows. Is there a way to copy conditional formatting, or do I just have to enter it all over again? |
Can I copy conditional formatting?
That would depend upon what your CF conditions are.
Are you using "Cell Value is:" or "Formula is:"? Do the CF's point to entire columns or ranges? The Format PaintBrush will do a lot for you, again depending upon conditions. Can you post a few examples? Gord Dibben MS Excel MVP On Mon, 2 Jun 2008 18:19:12 -0400, "Laurel" wrote: I have conditional formatting on some columns in my spreadsheet. I would like to put that same formatting on some rows. Is there a way to copy conditional formatting, or do I just have to enter it all over again? |
Can I copy conditional formatting?
See below.
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... That would depend upon what your CF conditions are. Are you using "Cell Value is:" or "Formula is:"? I don't know the difference. I put most of the formulae on using Office 2003, and forget how I did it. I now have Office 2007, and only know to go to "Conditional Formatting" on the Home tab, and click "Manage Rules." If a column letter is highlighted, or if any cell in the column in question is highlighted, I see 3 rules: Cell value between 120 and 139 - format is blue. " " " 130 and 159 - format is red. " " " 159 - format is fuschia. Note - one problem I didn't mention is that text labels I have in that column show up fuschia.... Not a big problem, but I wish I understood it. Do the CF's point to entire columns or ranges? Columns. The Format PaintBrush will do a lot for you, again depending upon conditions. How do I find that? If I enter "Format Paintbrush" in help, I get a bunch of topics relating to "formatting" (e.g., "format a disk") but nothing for Format Paintbrush. Can you post a few examples? See above Gord Dibben MS Excel MVP On Mon, 2 Jun 2008 18:19:12 -0400, "Laurel" wrote: I have conditional formatting on some columns in my spreadsheet. I would like to put that same formatting on some rows. Is there a way to copy conditional formatting, or do I just have to enter it all over again? |
Can I copy conditional formatting?
I do not use 2007 so cannot speak to that.
Gord On Sat, 7 Jun 2008 17:16:59 -0400, "Laurel" wrote: See below. "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . That would depend upon what your CF conditions are. Are you using "Cell Value is:" or "Formula is:"? I don't know the difference. I put most of the formulae on using Office 2003, and forget how I did it. I now have Office 2007, and only know to go to "Conditional Formatting" on the Home tab, and click "Manage Rules." If a column letter is highlighted, or if any cell in the column in question is highlighted, I see 3 rules: Cell value between 120 and 139 - format is blue. " " " 130 and 159 - format is red. " " " 159 - format is fuschia. Note - one problem I didn't mention is that text labels I have in that column show up fuschia.... Not a big problem, but I wish I understood it. Do the CF's point to entire columns or ranges? Columns. The Format PaintBrush will do a lot for you, again depending upon conditions. How do I find that? If I enter "Format Paintbrush" in help, I get a bunch of topics relating to "formatting" (e.g., "format a disk") but nothing for Format Paintbrush. Can you post a few examples? See above Gord Dibben MS Excel MVP On Mon, 2 Jun 2008 18:19:12 -0400, "Laurel" wrote: I have conditional formatting on some columns in my spreadsheet. I would like to put that same formatting on some rows. Is there a way to copy conditional formatting, or do I just have to enter it all over again? |
All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com