Now, the above is not exactly what is required but I couldn't think of a better way of wording it.

​

Essentially, I have an automatically refreshing sheet that pulls data from a finance system and displays the spend profiles for ~300 budget lines, this works fine 99% of the time. However, sometimes extra budget codes are added on the sly and these aren't picked up on the sheet, causing a discrepancy between the profile on the ledger.

​

To combat this, and to try and make the whole thing easier on the end user, I introduced a conditionally formatted matrix for budget codes at high level that pretty much works on the principle:

​

if x=y then we're good, if it doesn't, there's something that needs adding.

​

This works pretty well but as I'm tinkering with it more and more I'd like to be able to make this more straight forward for end users to spot what it is that's slipped through.

​

Sooo...(got there eventually)

​

What I'd like in an ideal world and have struggled to implement (and also not sure if it's possible), is the user to be able to select the cell that's throwing the error and run a macro with a message box that will evaluate both the x and y parts of the IF formula, ie Costs on Plan (x) = 100, Costs on ledger (y) = 101. That way the user knows they're looking for a value of 1 as opposed to manually traipsing through lines. If it could calculate the difference that would be even better.

​

https://preview.redd.it/cw7kyoy212731.png?width=1049&format=png&auto=webp&s=5605840363be6dc7efd0898ab0e45497544f465f

ie. Select the red cell - show the evaluated formula one step before introducing the "value if true", "value if false" part.

​

In fairness, the entire exercise is non essential, just a small QoL improvement I'd like to include.

​

As always, thanks in advance.

​

Leo