+ Reply to Thread
Results 1 to 2 of 2

Update Conditional Formatting for selected worksheets

  1. #1
    Registered User
    Join Date
    09-01-2015
    Location
    NC
    MS-Off Ver
    2013
    Posts
    11

    Update Conditional Formatting for selected worksheets

    I created a spreadsheet where there are different sheets that link to a composite.
    However, for example: On sheet number 1 I changed the conditional formatting to shade yellow if a value is out of wrong. If I want to update the conditional formatting for 30 more sheets, how would I do this?

    I tried deleting them and copying sheet number 1 30 more times, and that messed up the linking. I tried copying sheet number 1 over the rest, and it didn't update the conditional formatting.

    Any thoughts?
    Sample Sheet Master.xlsx

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Update Conditional Formatting for selected worksheets

    Hi
    Go to Sheet [1], select E7:E19 and copy
    with shift pressed select sheet [30]. So Sheet from [1] to [30] are grouped

    Go to Sheet [1], select E7:E19 and paste special formats.

    Attention: When the sheets are grouped, any change of a given cell causes change in that equivalent cell in all grouped sheets

    Go to another sheet that is not in the group to ungroup

    Your sheet [1] is distincted from [2], [3], ...

+ 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. Conditional formatting based on selected cell
    By andikeep2580 in forum Excel General
    Replies: 4
    Last Post: 12-30-2015, 06:46 PM
  2. Conditional Formatting to selected cells only
    By morerockin in forum Excel General
    Replies: 2
    Last Post: 02-02-2015, 11:17 AM
  3. Conditional formatting / VBA, based on selected time range
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2013, 07:45 PM
  4. Replies: 5
    Last Post: 11-27-2013, 06:04 PM
  5. Replies: 1
    Last Post: 06-12-2013, 12:23 PM
  6. [SOLVED] one conditional formatting for all selected rows
    By sanlen in forum Excel General
    Replies: 4
    Last Post: 04-06-2012, 12:57 AM
  7. Replies: 0
    Last Post: 08-03-2011, 08:40 AM

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