Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Is there a way to copy and paste ONLY the conditional formatting settings? In
other words I don't want the destination cells to acquire all the other formats (borders, font size, etc) of the source cell. -- Art |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I don't think you can copy and paste only part of the formatting. You can
however change the Applies To range for the conditional format to expand it to cover the additional cells you would like it to apply to. If your formatting uses formulas, make sure you absolute and relative references (ie $a$1 or A1) are appropriate for whatever you are trying to do. -- If this helps, please remember to click yes. "Art" wrote: Is there a way to copy and paste ONLY the conditional formatting settings? In other words I don't want the destination cells to acquire all the other formats (borders, font size, etc) of the source cell. -- Art |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Sort-of.
Select all the cells you want formatted (using Shift and/or Ctrl to select discontinuous ranges) and then select the cell with conditional formatting you want to copy. With the "source" cell being active, go into your conditional format rules. If its visible (which means the destination cells have no format already applied) Simply hit "Ok", and that format will be applied to all the cells. If the rules appear blank, you can either re-create the rule, or go back and first remove the conditioning from the 'destination' cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Art" wrote: Is there a way to copy and paste ONLY the conditional formatting settings? In other words I don't want the destination cells to acquire all the other formats (borders, font size, etc) of the source cell. -- Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |