R
robert morris
How do I copy conditional formating down to "X" number of rows?
Col A is Text
Cols B,D,F,H,J,L are numeric descriptions (every other col)
Cols C,E,G,I,K,M are columns in which I need to highlight the
Max number
I'm using =C7=MAX($C$7,$E$7,$G$7,$I$7,$K$7,$m$7)
I just do not know how to copy this formating down to additional rows
Col A is Text
Cols B,D,F,H,J,L are numeric descriptions (every other col)
Cols C,E,G,I,K,M are columns in which I need to highlight the
Max number
I'm using =C7=MAX($C$7,$E$7,$G$7,$I$7,$K$7,$m$7)
I just do not know how to copy this formating down to additional rows