Copying a conditional format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
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.mvps.org/dmcritchie/excel/condfmt.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do copy a conditional format formula downards? 1
CF 5
Conditional Format 1
Excel copy and paste 1
Conditional Formatting 3
Comparison of columns using Conditional Formatting 3
copy conditional formatting range 3
vlookup formatting problem 1

Back
Top