Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Paste conditional formatting
hi,
I have conditional formating on cell T17 condition is if sum of B17 to S17 is greater than 0.5 then the cell T17 should turn red (or specified color). I am using this equation =Sum(T17:S17) Condition is working fine on T17. I need to copy the same conditional formatting to T18, T20, T21, T23, T24, T26, T27 etc. I tried copy and paste special but it wont copy conditional formatting. Is there another way to copy paste? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Paste conditional formatting
Simply Copy the cell that contains the Conditional Formatting using the copy
button on the top toolbar, then select the other cells you wish to apply the formatting to, then select the Paste Special on the top toolbar and choose to copy "Formats" only in the list. B. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Paste conditional formatting
Here's how to copy-paste conditional formatting ONLY:
Select a cell that has the conditional formatting set already. Open the conditional formatting dialog. Under "Applies to", either type in the cell addresses (as a range, e.g., $A$5:$G$5) to which you want the conditional formatting to apply OR click on the red/blue icon and select the range manually in the spreadsheet. Click OK. The above works for Excel 2007. As I recall, it worked for 2003 as well. Hope this helps. (Don't you wish the Help files would tell you this? Maybe they do somewhere, but if you type in a search term like "Paste conditional formatting", you get 100 results none of which are on point, or if they are, the title of the Help page doesn't clue you in on which one to choose.) On Oct 17, 10:45*am, Raz wrote: hi, I haveconditionalformating on cell *T17 condition is if sum of B17 to S17 is greater than 0.5 then the cell T17 should turn red (or specified color). I am using this equation =Sum(T17:S17) Condition is working fine on T17. I need tocopythe sameconditionalformattingto T18, T20, T21, T23, T24, T26, T27 etc. I triedcopyand paste special but it wontcopyconditionalformatting. Is there another way tocopypaste? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional formatting, paste format without conditions | Excel Discussion (Misc queries) | |||
How to copy and paste conditional formatting for the cell next to | Excel Discussion (Misc queries) | |||
Conditional formatting - copy & paste to an email | Excel Discussion (Misc queries) | |||
Copy paste Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Paste Conditional Formatting | Excel Discussion (Misc queries) |