Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formats on a List
I have right clicked a selection on excel and created a list. On this
list I have also added conditional formatting to color the cells in each column a different color. When I add new things to the bottom of the list the Conditional formatting does not always follow along. Most of the formatting seems to go away as well. Any help would be greatly appreciated. Thanks, Jay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formats on a List
Use the FORMAT PAINTER icon (paint brush) to paint the format settings from the last entry in your current list into the * row, the expansion row that appears when your cursor is in the List somewhere. Then exit the list, then reenter the list and add a new row using the * row. Should work from then on. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46803 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formats on a List
On Jan 5, 4:41*pm, JBeaucaire
wrote: Use the FORMAT PAINTER icon (paint brush) to paint the format settings from the last entry in your current list into the * row, the expansion row that appears when your cursor is in the List somewhere. Then exit the list, then reenter the list and add a new row using the * row. Should work from then on. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile:http://www.thecodecage.com/forumz/member.php?userid=73 View this thread:http://www.thecodecage.com/forumz/sh...ad.php?t=46803 JB This is a no go. As soon as I click out side the box it goes away. I could do this with a Macro, but I did not want to have users have to enable macros. I just want the format to carry down inside the list box. Thanks, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
Excel, how to copy conditional formats in sequential order 1,2,3 | Excel Worksheet Functions | |||
How do I copy conditional formats so it changes cell references? | Excel Worksheet Functions | |||
list all conditional formats | Excel Worksheet Functions | |||
How to create Conditional Formats that "grow" with copy/fill down. | Excel Discussion (Misc queries) |