R
robert morris
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?
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?