?? copy conditional formating

[Guest]

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

 

[Guest]

Sounds like a question for an Excel newsgroup and no for one for Access, a
relational database.