Conditional formatting
 

I am working with some conditional formatting involving formulas:
=$D$5=.001, format the text red for cells =$B$5:$D$5

My problem is this, if you copy any of the values in the cells that have the
conditional format above, another rule is created and i have to delete that
rule.
For example, if I copy the values in B5 and C5 and copy to B18 and C18,
under Manage Rules, for current selection and this workbood, an extra rule is
created.
=$D$5=.001, red text applies to $B$18:$C$18. How do I prevent this from
happening?

Conditional formatting
 

When you copy, use the right click menuCopy, then Paste SpecialValues or
Formulas. Just make sure Paste SpecialFormats is not selected.

--
Biff
Microsoft Excel MVP


"Tuffy" wrote in message
...
I am working with some conditional formatting involving formulas:
=$D$5=.001, format the text red for cells =$B$5:$D$5

My problem is this, if you copy any of the values in the cells that have
the
conditional format above, another rule is created and i have to delete
that
rule.
For example, if I copy the values in B5 and C5 and copy to B18 and C18,
under Manage Rules, for current selection and this workbood, an extra rule
is
created.
=$D$5=.001, red text applies to $B$18:$C$18. How do I prevent this from
happening?

Conditional formatting
 

Thanks! That helped.

"T. Valko" wrote:

When you copy, use the right click menuCopy, then Paste SpecialValues or
Formulas. Just make sure Paste SpecialFormats is not selected.

--
Biff
Microsoft Excel MVP


"Tuffy" wrote in message
...
I am working with some conditional formatting involving formulas:
=$D$5=.001, format the text red for cells =$B$5:$D$5

My problem is this, if you copy any of the values in the cells that have
the
conditional format above, another rule is created and i have to delete
that
rule.
For example, if I copy the values in B5 and C5 and copy to B18 and C18,
under Manage Rules, for current selection and this workbood, an extra rule
is
created.
=$D$5=.001, red text applies to $B$18:$C$18. How do I prevent this from
happening?

Conditional formatting
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Tuffy" wrote in message
...
Thanks! That helped.

"T. Valko" wrote:

When you copy, use the right click menuCopy, then Paste SpecialValues
or
Formulas. Just make sure Paste SpecialFormats is not selected.

--
Biff
Microsoft Excel MVP


"Tuffy" wrote in message
...
I am working with some conditional formatting involving formulas:
=$D$5=.001, format the text red for cells =$B$5:$D$5

My problem is this, if you copy any of the values in the cells that
have
the
conditional format above, another rule is created and i have to delete
that
rule.
For example, if I copy the values in B5 and C5 and copy to B18 and C18,
under Manage Rules, for current selection and this workbood, an extra
rule
is
created.
=$D$5=.001, red text applies to $B$18:$C$18. How do I prevent this
from
happening?