+ Reply to Thread
Results 1 to 2 of 2

Creating conditionally format cells based on formatted cells in another sheets

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    Görlitz, Germany
    MS-Off Ver
    2013
    Posts
    1

    Question Creating conditionally format cells based on formatted cells in another sheets

    Hello everybody,

    I have a Excel-spreadsheet with 5 worksheets. The first worksheet is build like a mainmenu, which contains hyperlinks to the 4 other worksheets. The 4 other worksheets are containing conditionally formatted cells. Is it possible, to create conditionally formatted cells for each worksheet in the main menu / Sheet 1, which are getting red if something is formatted red in the specific worksheet? I've searched around the internet but no one has got a familiar problem, because I want to use more worksheets.

    You can imagine it like this:

    Sheet 1 / Menu

    Link to Sheet 2 Cell turns red if something gets formatted red in Sheet 2
    Link to Sheet 3 Cell turns red if something gets formatted red in Sheet 3
    ...
    ...

    Sheet 2 - If something turns red here, it will automatically be "send" to the specific mainmenu cell, linked with this sheet

    A
    B
    If I am Bigger than B1 I will turn red Number 1
    If I am Smaller than B2 I will turn red Number 2

    I hope you can help me solving this problem
    Kind Regards

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

    Re: Creating conditionally format cells based on formatted cells in another sheets

    Conditional Formatting cannot determine the colour of a cell, ie if it is red on Sheet 2.
    If there is a conditional format that set the colour red on Sheet 2 then just use the same rules that turned it red in the first place.
    If the cell was turned red not by conditional formatting then VBA is the only way to determine the colour of a cell.

    I'm using Excel 2013 which allows you to Condtional Formatting when referring to other sheets (which I didn't think you could do).
    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)

Similar Threads

  1. Linking conditionally formatted cells to other sheets in smae workbook
    By guins in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-28-2015, 09:58 PM
  2. Auto skip colored cells VBA but include conditionally formatted cells also
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2014, 03:44 AM
  3. Macro to Conditionally Format Cells based on another cells value
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-07-2013, 03:05 AM
  4. Linking conditionally formatted cells from one to another maintaining the format
    By adkinsj3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 05:06 PM
  5. Replies: 6
    Last Post: 02-16-2013, 05:12 AM
  6. Replies: 7
    Last Post: 01-28-2011, 10:07 AM
  7. Conditionally Format Row based on Multiple Cells in Row
    By todd.debacker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2007, 03:56 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