Conditionally Format known Cell Address - based on data changing in another cell

I am trying to conditionally format a specific cell when I know the exact cell I want to format within an array of data. For instance given an array of data A1:J10, and given another cell K1. When the data in K1 changes, based on other formulas I am already doing, I can determine the cell address I want to highlight within A1:J10.

Example.

The data value in cell K1 changes and based on that it is determined that I want to change the format of the cell C8; i want it to be bold, green fill, and red text. The formula I have sets the value in cell K2 to the text value "C8". So now I have determined and put the value of the cell I want to format in cell K2.

When the data in K1 changes again, it is determined that now I want the format in cell H3 to be the one with the format changed, and C8 to go back to normal. So K2's value changes to "H3".

This part works.

So I know I want to use conditional formatting applied to the array A1:J10, but I want to base it on giving it the specific cell I have already determined. I thought I could use the row() and column() functions together in a conditional function formula given that I know the coordinates...but I couldn't make it work.

Anyone have an idea on how to solve this?

Hello Spike281,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

Please post your question in one of the Microsoft Office Application Help - Excel Help forums in order to get help.
I feel that this request fits in either the General or VBA forum.
Please utilize the instructions for uploading sample .xlsx files given in the banner at the top of the page so that contributors can better understand the request.
Let us know if you have any questions.

Originally Posted by JeteMc

Please post your question in one of the Microsoft Office Application Help - Excel Help forums in order to get help.

Moderator note: I have moved it. We prefer that such posts be reported so we can move them, rather than posting duplicates.