+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting when cells are from certain sheets

  1. #1
    Registered User
    Join Date
    06-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Question Conditional Formatting when cells are from certain sheets

    Ok In the attached document there are 3 sheets:
    • Sheet 1 (Combined)
    • Sheet 2 (Data Text 1)
    • Sheet 3 (Data Text 2)

    Sheet 1 combines the data in sheet 2 and sheet 3 by referencing the cells in those sheets. What I want to do is conditionally format the cells on sheet 1 (combined) red when the data referenced is from Sheet 2 (Data Text 1) and blue when the data is referenced from Sheet 3 (Data Text 2). I have tried everything and I can't get it to work. What I don't want to do is create additional columns (e.g. create a new column in column b in Sheet 2 that says Data Text 1 and the same for Sheet 3 and then on sheet 1 check if the text in column b ="Data Text 1". Is it possible to conditionally format a cell based on its formula? Then I could get it to work as I could just format the cell if the formula of the cell =DataText1!A2...etc.etc. I am open to suggestions and ideas that might be outside the box. Thank you so much!!!
    Attached Files Attached Files

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Conditional Formatting when cells are from certain sheets

    Create two Dynamic Named Ranges
    "Data1" Refers to
    Please Login or Register  to view this content.
    "Data2" Refers to
    Please Login or Register  to view this content.
    Then C/F
    Condition 1
    Please Login or Register  to view this content.
    Format "Red"

    Condition 2
    Please Login or Register  to view this content.
    Format "Blue"
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    06-08-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Conditional Formatting when cells are from certain sheets

    Thank you so much Marcol, you are a life saver this is so helpful. I would have never have been able to come up with this on my own it is completely beyond me! THANK YOU!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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