Custom format the selected cell using conditional formatting..

[omairhe]

Hey all,

I would like to underline the value in selected cell using conditional formatting along with Application.Calculate method.

I have achieved this with formatting the row and column with formula's such as

=COLUMN()=CELL("col")
=CELL("row")=ROW()

=$A$1:$DZ$1
=$A$1:$A$600

respectively

so that the above procedure will underline cell in row 1 and cell in column 1 but what formula is to highlight the active cell? thus giving me 3 underlined cells not just 2.

Also can I combine all three in a single line to save me trouble of making three separate conditional formatting rules.

Thanks in advance and much appreciation.

 

[shg]

=(COLUMN() = CELL("col")) * (ROW() = CELL("row"))