software

Is there a way to drag (not copy) conditional formatting across multiple rows?

I would rather not format every single row

quot;Frawstquot; gt; wrote in message
...
gt; Is there a way to drag (not copy) conditional formatting across multiple
gt; rows?
gt;
gt; 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

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.

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 gt;
wrote:

gt;Is there a way to drag (not copy) conditional formatting across multiple rows?
gt;
gt;I would rather not format every single row 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

nwexcelsolutions.com
quot;Frawstquot; gt; wrote in message
...
gt; Beege,
gt;
gt; Thanks for the quick response.
gt; My problem is that there's a row specific reference in the conditional
gt; formatting, so I really need a drag and fill.
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)

quot;bpeltzerquot; wrote:

gt; What is your condition (ex: quot;formula isquot; quot;=b1=4quot;)? If you've got relative
gt; references in the formula (that is, b1 and not $b$1), they should adjust
gt; properly if you copy the CF.
gt;
gt; quot;Frawstquot; wrote:
gt;
gt; gt; Beege,
gt; gt;
gt; gt; Thanks for the quick response.
gt; gt; My problem is that there's a row specific reference in the conditional
gt; gt; formatting, so I really need a drag and fill.

What is your condition (ex: quot;formula isquot; quot;=b1=4quot;)? 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.

quot;Frawstquot; wrote:

gt; Beege,
gt;
gt; Thanks for the quick response.
gt; My problem is that there's a row specific reference in the conditional
gt; formatting, so I really need a drag and fill.