View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tuffy Tuffy is offline
external usenet poster
 
Posts: 3
Default 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?