View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default ??? Copy conditional formating


I do not know how to copy conditional formating down to additional rows

Col A is Text
Col B,D,F,H,J,L are numeric descriptions (every other column)
Col C,E,G,I,K,M are columns which i need to hightlight the Max number

I'm using =C7=MAX($C$7,$E$7,$G$7,$I$7,$K$7,$M$7)

This highlights the Max number, but I can't copy it down to additional rows

Any answers?