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

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

"D" wrote in message
...
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

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" wrote:

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

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"BoniM" wrote in message ...
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" wrote:

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

And your formula actually needs to be:
=C3=MAX($C$3:$E$3)

"D" wrote:

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

Hi,

For more information on Conditional Formatting, refer to this link:
http://office.microsoft.com/en-us/ex...CL100570551033

Challa Prabhu


"D" wrote:

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