 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007unconditional formatting copy below
Hi all, How to copy unconditional formatting to the below 10 rows? For example H2,J2,L2 is having "Bottom 1 items" formatting. How to copy the same formatting to the below rows? Thanks for any replies. Trish Hi Mark the row number that has the formatting you want to copy. Click the format painter icon. Mark the row number of the rows you want to receive the formatting, with the painter icon.  SignatureRegards Roger Govier > Hi all, > [quoted text clipped - 5 lines] > > Trish You can *double* click the format painter icon to keep it "in force" when the cells to format are *not* contiguous, and you must click individually on each cell. When finished using it, hit <Esc> to de-select the icon. SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== Hi Mark the row number that has the formatting you want to copy. Click the format painter icon. Mark the row number of the rows you want to receive the formatting, with the painter icon. SignatureRegards Roger Govier > Hi all, > [quoted text clipped - 5 lines] > > Trish > You can *double* click the format painter icon to keep it "in force" when > the cells to format are *not* contiguous, and you must click individually [quoted text clipped - 19 lines] >> >> Trish Both the answers doesn't work. Some other advice please. Normal formatting and Unconditional formatting are two different thing I guess. Trish I'm familiar with "formatting" and "conditional formatting". What's your definition of "unconditional formatting"? And could you elaborate on exactly what you're referring to when you say, "bottom 1 items formatting". SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- >> You can *double* click the format painter icon to keep it "in force" when >> the cells to format are *not* contiguous, and you must click individually [quoted text clipped - 24 lines] > > Trish err my mistake. Not Unconditional formatting it's Conditional Formatting. > I'm familiar with "formatting" and "conditional formatting". > [quoted text clipped - 31 lines] >> >> Trish thanks for the reply. I am using `Microsoft Office Excel 2007'. Under `Conditional Formatting' --> there is `Below 1 items'. Selected this formatting on a row (H2,J2,L2). How to copy the same conditional formatting on the below 10 rows? Trish Hi Conditional Formatting>Manage Rules>change entry in Applies to field, to cover the range you want the CF applied to. SignatureRegards Roger Govier > thanks for the reply. I am using `Microsoft Office Excel 2007'. > [quoted text clipped - 4 lines] > > Trish Just thinking ... someday I'll *have* to eventually use XL07 ! ? ! SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Hi > [quoted text clipped - 9 lines] > > > > Trish Hi Rick Once you do, you will be pleased. It only takes a short while to get used to the ribbon, and there are now plenty of ways to Customize that. I'm sure SP1 will be along before too long which will hopefully address some of the "issues" which have arisen. SignatureRegards Roger Govier > Just thinking ... someday I'll *have* to eventually use XL07 ! ? ! > [quoted text clipped - 12 lines] >> > >> > Trish I'll wait as long as I can!<bg> SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- Hi Rick Once you do, you will be pleased. It only takes a short while to get used to the ribbon, and there are now plenty of ways to Customize that. I'm sure SP1 will be along before too long which will hopefully address some of the "issues" which have arisen. SignatureRegards Roger Govier > Just thinking ... someday I'll *have* to eventually use XL07 ! ? ! > [quoted text clipped - 12 lines] >> > >> > Trish What, maybe till Excel 14??? <bg> SignatureRegards Roger Govier > I'll wait as long as I can!<bg> > Hi Rick [quoted text clipped - 23 lines] >>> > >>> > Trish |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.