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