Hello,
I have an index/match formula in a cell on a sheet named "Overview by Specialty". The information is being pulled from a sheet named "Consolidated". I am trying to figure out how to keep the formatting from the consolidated tab. Conditional formatting would require an infinite number of additional look-ups and rules per cell. Through some research, I believe the formatting can be preserved via VBA, but I am not skilled in this arena. The only cells on the consolidated tab that are formatted are the ones I am referencing in the index/match.
Any suggestions? Thank you in advance!
I have an index/match formula in a cell on a sheet named "Overview by Specialty". The information is being pulled from a sheet named "Consolidated". I am trying to figure out how to keep the formatting from the consolidated tab. Conditional formatting would require an infinite number of additional look-ups and rules per cell. Through some research, I believe the formatting can be preserved via VBA, but I am not skilled in this arena. The only cells on the consolidated tab that are formatted are the ones I am referencing in the index/match.
Any suggestions? Thank you in advance!
