I have a problem. I try to make a macro to change a color of a cell/cells based on what is a value in another cell.
F.e. the value of a cell A1 is "A5". How to make a macro that then changes color of the cell "A5" to red, and if the value of the cell A1 is changed to "B6", then it changes the color of the cell B6 to red.
I need to use this in a long list of items and each item contains a cell code that should be colored (its like a map that shows where that item is located).
I guess it could be done by using "indirect" function, but it is not available as a worksheetfunction in VBA.