Copying a Conditional Formatting Formula

S

Seanie

I am tyring to copy a CF formula, using Copy - Paste Special -
Formats, but it is not retaining the relative references within the CF
formula. Am I doing something really silly here thats preventing this?

My CF formula is

=AND($A8+($A8<$AA$1)>=($AB$1+(30/1440)),$A8+($A8<$AA$1)<=($AB
$1+(30/1440))+(($AB$1+(30/1440))<$AA$1))

This is in D8, so in D9:D31 I expect only A8 to change to A9; A10 etc,
but it stays at A9 in the cells D9:D31
 
P

Per Jessen

Hi

Have you tried using the format painter?

Select D8, activate the format painter and drag down to D9:D31.

Hopes this helps.
...
Per
 
A

Ashish Mathur

Hi,

You may use the format painter. Select D8 and then click on the paint
brush. Then just select D9:D31 and release the left mouse key

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stripe out duplicate data 5
set formula to display a data from a 5 columns table 3
Not so simpel copying of a simple formula 5
data validation with a formula 7
Nesting the ROW() command into a Conditional Format Formula 4
Copying hyperlinks on a 'relative' basis 1
help with a conditional formatting formula 2
Copy Conditional Formatting down rows 5

Top