+ Reply to Thread
Results 1 to 2 of 2

Format different random cells with same formatting

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    260

    Format different random cells with same formatting

    In my spread sheet I would like to apply the same formatting to different cells that I may highlight at different times (there are many).
    When I record a Macro I get the following code:
    Please Login or Register  to view this content.
    This unfortunately will continue to Border only the A134:N134 cells.
    How may I change the code so that the Macro will apply the border to any cells that I may highlight?

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Format different random cells with same formatting

    If you want to use the code for the selection done in the sheet just use
    You just then to select some cells and launch the macro

    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formatting cells other than select-highlighting the cells to apply the format?
    By Joe Miller in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-27-2014, 10:53 AM
  2. [SOLVED] Conditional Formatting to Use a formula to determine which cells to format
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-16-2013, 10:29 AM
  3. Format Cells, auto formatting.
    By patrikkoo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-01-2008, 11:06 PM
  4. format cells-how can i set by default the cell formatting
    By notrace2004 in forum Excel General
    Replies: 2
    Last Post: 05-29-2006, 03:03 AM
  5. Formatting cells in hh:mm format
    By yagerman42 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2005, 04:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1