Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
Is there a way to drag (not copy) conditional formatting across multiple rows?
I would rather not format every single row :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
"Frawst" wrote in message
... Is there a way to drag (not copy) conditional formatting across multiple rows? I would rather not format every single row :) Frawst, You could have selected multiple rows prior to formatting to format all at once, or immediately after conditional formatting, select next row to cf, hit F4.... (you could even skip rows here) Beege |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
Beege,
Thanks for the quick response. My problem is that there's a row specific reference in the conditional formatting, so I really need a drag and fill. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
Frawst
Use the Format Painbrush icon. Don't forget to double-click the Brush to lock it on as you select cells and rows. Single-click when done to unlock. Gord Dibben MS Excel MVP On Mon, 17 Apr 2006 10:44:36 -0700, Frawst wrote: Is there a way to drag (not copy) conditional formatting across multiple rows? I would rather not format every single row :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
Select the cell with the formatting, double click on the paint brush then
you can just select the rows you want to format, finish by pressing escape or click the paint brush again once -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Frawst" wrote in message ... Beege, Thanks for the quick response. My problem is that there's a row specific reference in the conditional formatting, so I really need a drag and fill. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
Beege,
it is a $ reference, at the top of the row. If I remove it it floats down the row. I need the absolute reference (I honestly think the answer is suck it up and format each of your rows, I just wanted to make sure I wasn't missing something before I did) "bpeltzer" wrote: What is your condition (ex: "formula is" "=b1=4")? If you've got relative references in the formula (that is, b1 and not $b$1), they should adjust properly if you copy the CF. "Frawst" wrote: Beege, Thanks for the quick response. My problem is that there's a row specific reference in the conditional formatting, so I really need a drag and fill. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Conditional Formatting
What is your condition (ex: "formula is" "=b1=4")? If you've got relative
references in the formula (that is, b1 and not $b$1), they should adjust properly if you copy the CF. "Frawst" wrote: Beege, Thanks for the quick response. My problem is that there's a row specific reference in the conditional formatting, so I really need a drag and fill. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |