Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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". |
#2
|
|||
|
|||
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Meaux" wrote in message ... 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". |
#3
|
|||
|
|||
Hi,
Try this =$h4.5 and copy this down for other cells in the column Thanks K.S.Warrier "Meaux" wrote: 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) | |||
Conditional Format With SUMIF | Excel Worksheet Functions |