Conditional Formatting: Highlight when referenced

What you are describing is pretty clear, but it would be very helpful if you could provide a sample file with this kind of setup. Please see yellow banner at the top of the page.

At first glance I am thinking this is going to require VBA, and possibly a volatile function, so could be a performance pig depending on how many formulas you have.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I shall post the links for you this time: https://chandoo.org/forum/threads/co...erenced.48570/ and https://www.mrexcel.com/board/thread...rence.1212755/)

Unfortunately I can't share the file but I would appreciate any help!

We don't need or expect to see THE file, but yes, you CAN share a sample file. This may require a bit of effort on your part, but if you are expecting help from us and members of two other forums, then it's the least you can do.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Also what does the "+" in "2013+" mean? The solution is going be dependent on which version of Excel you use. Does this mean 2013 and all later versions?