+ Reply to Thread
Results 1 to 2 of 2

Mirroring exact cell attributes from 1 sheet to another inc conditional formatting

  1. #1
    Registered User
    Join Date
    01-28-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2013 (PC)
    Posts
    24

    Mirroring exact cell attributes from 1 sheet to another inc conditional formatting

    OK probably a very basic copy & paste solution to this but cant see it.

    I've got a cell with a number in it and conditional formatting attatched to it.

    So when a certain value is entered it turn either Red Amber or Green.

    I would like to have this appear the exact same (with cell colours) on a different sheet.

    I can obviously do =sheet1!A1 but that only takes the value and not the colour its changed to.

    Is this possible with out doing the conditional format on every sheet?

    Thanks for any help,
    Ewen

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Mirroring exact cell attributes from 1 sheet to another inc conditional formatting

    Dont think so, you gotta repeat the conditional format on each sheet.
    Just select the cell, click Format Painter (the paintbrush), change sheets and select the new cell.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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