| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
??? Copy conditional formating
Gord,
Thanks very much. Very good explanation. Bob "Gord Dibben" wrote: So that the 7 in $C7 will increment to 8, 9, 10 etc. as you copy down. See help on Absolute and Relative cell referencing. Gord Dibben MS Excel MVP On Mon, 7 May 2007 13:14:00 -0700, robert morris wrote: Max, Thanks so much, that worked. What I don't understand is why I would have "$C7 and remove the $ sign on the row. Many thanks, Bob " wrote: On 7 Mag, 21:29, robert morris wrote: 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? You can try removing $ just before the row index: =C7=MAX($C7;$E7;$G7;$I7;$K7;$M7) Then you can copy it down Hope it helps Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating IS: Help With ANY VALUE | Excel Discussion (Misc queries) | |||
| How do i copy conditional formating formulas from 1 row to rest | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
| Conditional formating | Excel Discussion (Misc queries) | |||
Threaded Mode
