View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C Tate
 
Posts: n/a
Default Conditional formatting

I am trying to use conditional formatting so that if cell b2 is greater than
a2 the number will be coloured red. I then want to apply this to a range so
that the references will change automatically. What is the best way to do
the formula?