View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
if you want to highlight always the active cell you need VBA. See:
http://www.cpearson.com/excel/excelM...ightActiveCell

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
ps.com...
I have the followint formula in a conditional format.
=ROW()=ROW(INDIRECT(CELL("address")))
I remember getting it from this group, it highlights the active cell

in
yellow.
I cannot delete it and I believe it will not allow me to copy and

paste
data about the spreadsheet.
I need to delete as I need to copy and paste more than I need the
active cell highlighted.