Thanks for your response. I posted my question in more detail on the thread
"Need a "Tailored" Highlighting Macro". There's some really good code in
there, I'm just wondering if it can be changed to fit my desired highlighting
format. If you have any feedback to that thread, please respond on it.

"JE McGimpsey" wrote:

You can get the current row/column numbers using the CELL function, so
you could use the CF:

Formula is =OR(CELL("row")=ROW(),CELL("col")=COLUMN())

however, you'd need to cause a calculation (either via F9, or perhaps
via the _SelectionChange event) to get the CF to update.

And I suspect if you apply it to a large area, you're going to take a
performance hit.

In article ,
dschanak wrote:

This is a cool add-in, but is there a way to write something like this into
the code? I was thinking I could do it by somehow getting the current row
number and column number in 2 separate cells, and then apply a conditional
format to the column titles and row titles that bolds/colors/etc if the cell
value matches the column/row number. But I don't know how to get the current
row or column numbers. Any suggestions?