INDIRECT with a table row
Posted on 2011-09-19
I am creating a conditional formatting formula in VBA. I have the following formula working just fine:
In this case, the entire row is shaded when column D and the current row is equal to Employee.
I now want to make this work on a bunch of different data tables where the Status Column = Mapped. I am struggling on how to make this formula dynamic enough to reference the row in the data table where the value of Status = Mapped. I am at a loss at the moment on how to do that most efficient.
I see the formula looking something like =indirect( <the Status column> & ROW()) = "Mapped". I do not know how to properly address <the Status column>
Any tips would be appreciated.