Copying a conditional format

Copying a conditional format

Post by TWVhdX » Mon, 29 Nov 2004 06:41:01


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".
 
 
 

Copying a conditional format

Post by David McRi » Mon, 29 Nov 2004 07:44:15

You can use the "Format Painter" toolbar icon to copy Conditional Formatting,
but it would be a lot better to format everything that it might apply to
ahead of time as long as the range is continuous it should be more
efficient. (looks like a paint brush, not the paint buckets).

I have a page on Conditional Formatting
http://www.yqcomputer.com/
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.yqcomputer.com/
Search Page: http://www.yqcomputer.com/

 
 
 

Copying a conditional format

Post by Sy5TLldhcn » Tue, 30 Nov 2004 19:19:01

Hi,
Try this
=$h4>.5
and copy this down for other cells in the column
Thanks
K.S.Warrier