Highlight Current Row and Colum

[sgamble6]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to make it so I can have the all of the current row and all of the current column highlighted. I have a sudo solution using conditional formating.

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

but the problem is that the when I move the cursor around with the arrow keys only the cells surrounding the cursor update, not the entire sheet.
( see pictures

)
Is there an easier way to do this.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to make it so I can have the all of the current row and all of the
current column highlighted. I have a sudo solution using conditional
formating.

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

but the problem is that the when I move the cursor around with the arrow keys
only the cells surrounding the cursor update, not the entire sheet.
( see pictures

)
Is there an easier way to do this.

I think there are repaint issues. The conditional formatting should have 2
conditions, one for row, and another for column. With A1 selected, the
conditional formulas should be =cell("row")=row(a1); and
=cell("col")=column(A1)

Doing this produces a lot of very weird results as the cursor moves around.
I'll report it.

 

[sgamble6]

Thanks, one thing that I have found that fixes it is if I press cmd-A , for select all then all of the conditional formating realigns.

 

[JE McGimpsey]

Is there an easier way to do this.

As Bob wrote, there *is* a window repainting issue - I've seen and
reported it with other conditions, too.

However, the primary source of the problem that you're seeing is that,
given how CELL() is supposed to work, the CF *shouldn't* be working at
all.

If the cell reference is omitted, the evaluated cell is supposed to be
the last cell that was *changed*.

Since cells aren't changed simply by being selected, the CF should NOT
be updating as you select cells.

You can see the correct behavior if you enter

=CELL("row")

in a cell - the result is constant until an entry is made in another
cell.

All of which is a long-winded way of saying, since you're taking
advantage of an improper implementation of Conditional Formatting, it's
unlikely this will be a high-priority fix (and that if it IS fixed, it
shouldn't do what you want it to).

That said, you can force the refresh by typing CMD-A after your
penultimate arrow keypress, then arrow to your desired cell.

FWIW, both XL04 and WinXL07 show different errors when using this CF.