Highlight active row and column without VBA or Macros

Hi all

Does anyone know of a way to highlight the row and column of a cell that you click on, but without using VBA or Macros?

This would be very handy as I have data to enter on the right side of the screen, and would like a way to glance over the name of the person
on the left side of the screen, if it was highlighted.

I've seen some ways to do this using VBA or Macros, but I can't use those as I don't have a dedicated computer in work.

Also, our firewall can interpret VBA and macros as virus attacks and auto disable their use.

Anything like a setting used in financial stock market computer display, that kind of thing you see on the financial news channels.

Thanks

Barneysplash

you can try this but IMHO this is annoyed a bit but no vba
this is idea only

Try using this as the CF formula: =OR(CELL("col")=COLUMN(),CELL("row")=ROW())
Should highlight row and column of the cell you click on.