Dynamic row & column highlights in a data table

[Naz555]

Hi Peeps,

Happy new year to you all!

I have a two way data table for which the two variables are changed frequently. In the data table, for ease of reference, i usually highlight the corresponding row and column of the two most current variables the intersection of which gives you the current output. But these highlights need to eb changed each time the variables are changed 9the table is copied onto another document for presentation hence the need to keep changing the highlights).

I was thinking of configuring the highlighting process to happen dynamically, i.e. the row and column highlights change dynamically when the variables are changed. Could any of you suggest how this could be done?

Ive also attached an excel working exemplifying my situation.

Cheers,

Naz