conditional format

D

D

I am trying to copy and paste a conditional format to onsequtive rows below,
everytime I paste the original row is pasted too. How can i copy and paste a
copnditional format and ensure the new row is recognised. I am using format
to highlight a maximum value e.g =max($C$3:$e$3)

Thanks

D
 
D

David Biddulph

You'll need to look at the difference between absolute and relative
references for cells; Excel help will tell you.
 
B

BoniM

If you have C3 set with the conditional format, select the range C3 to E3 and
then go to conditional formatting. You should see your setting for the first
cell. Click OK and it is now applied to the entire row.
 
D

David McRitchie

I guess there are several interpretations of what you want.
If you just want to paste the formatting use the "Format Painter"
but you should be aware that it is a lot more efficient to set
the conditional formatting for entire columns or just what you
will be needing ahead of time rather adding C.F. piecemeal.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you want the C.F. to change row to row then remove the
$ from in front of the column in your C.F. formula.
 
Top