|
Posted to microsoft.public.excel.misc
|
|
|
conditional formatting
Thank you very much!
"John James" wrote:
Hi Patricia,
To explain the weird results:
1. The formula you type is relative to your cursor location. e.g. If
the cursor is in, say, cell A2 and you press Ctrl-A, the worksheet is
selected BUT the cursor remains in A2, which is in row 2. When you
then enter =$A1<0 in the conditional format, excel looks at the value
in A1 to determine the formatting for row 2!!! However, if the cursor
was in cell A1 when you pressed Ctrl-A, it would have worked. You'll
notice when you select the entire sheet with the mouse, the cursor
actually jumps to cell A1 - and that's why it worked when the sheet was
selected with the mouse, but didn't work when you pressed Ctrl-A.
2. If you want to edit the formula in the conditional formatting entry
area, then press the F2 key to change to edit mode.
Cheers,
Patricia Shannon Wrote:
Thanks. I finally got it to work by choosing the whole table by
clicking on
the "cell" that is above the 1st row and left of the 1st col.
When I tried to select the whole sheet with CTRL+A, I got weird results
of
coloring; also, in this case, when I would go back to the conditional
format,
it had changed, and as I was looking at it, if I accidently moved the
mouse,
the cursor would move around the workbook and change the formula.
However, I still have the problem that if I try to change the formula,
it
replaces the formula with a cell address, and I have to totally retype
the
formula if I want to change it.
--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532419
|