• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting: Highlight when referenced

baudiasuev

New Member
Hello,

I have somewhat of a unique conditional formatting request and I'm not even sure that this can be done but thought I'd ask anyways. I am looking for a way to highlight cells that are referenced in a formula somewhere else.

For example, Sheet1 has 10 formulas in which the data is coming from Sheet2. In order to make sure that all the numbers from Sheet2 are being placed somewhere in Sheet1, I would want them to turn green if Excel detects that that exact cell reference was used to make a calculation.

Please let me know if you know a way or want me to explain in more detail!

Thank you!!
 
baudiasuev
Please reread Forum Rules - those are for You too:
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
 
Back
Top