T
Tuffy
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?
=$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?