View Single Post
  #1   Report Post  
Meaux
 
Posts: n/a
Default Copying a conditional format

Is there a way to copy just the conditional format of a cell that uses a
formula as its condition. Such as "=h4.5" . What I want to do is use the
same format for different cells down a column. The "h4" has to change to
whatever row the copied format is on. So if I copy the conditional format on
"A4" that has the formula "H4.5" and copy it to row "5" the conditional
format should read "H5.5".