Id appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at one
time but responded erratically to changes in cell entries. What I did was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose €œFormula is€�
*enter =if($A$1=€�€�,TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Heres the problem. When I typed into cell A1 a few random letters, some of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows is
now correct.

The conition should be just:

Formula Is =$A$1=""
__________________________________________________ ______________________

"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

Thank you, but the same problem is still there.

"Vasant Nanavati" wrote:

The conition should be just:

Formula Is =$A$1=""
__________________________________________________ ______________________

"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

Actually, I think it's a screen repainting issue. Not sure what's causing
it.
__________________________________________________ _____________________


"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

Thank you for trying.

Can someone else help?

"Vasant Nanavati" wrote:

Actually, I think it's a screen repainting issue. Not sure what's causing
it.
__________________________________________________ _____________________


"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

I can't help other than to say =if($A$1="",TRUE, FALSE) does as it should.

Also =$A$1="" works for me.

With A1 empty............color

With anything in A1.............no color rows 1:10

I think you should not be looking at Excel as the source of your problem.

Perhaps a video driver issue?


Gord Dibben MS Excel MVP

On Sun, 17 Jun 2007 05:39:00 -0700, johnston
wrote:

Thank you for trying.

Can someone else help?

"Vasant Nanavati" wrote:

Actually, I think it's a screen repainting issue. Not sure what's causing
it.
__________________________________________________ _____________________


"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

Thank you for the reply. I also found an article on the Microsoft website
(http://support.microsoft.com/kb/213243/en-us) titled "Odd refresh behavior
after you specify a conditional format in Excel." Could this be applicable?

Any advice on how to check the video driver?

Thanks

"Gord Dibben" wrote:

I can't help other than to say =if($A$1="",TRUE, FALSE) does as it should.

Also =$A$1="" works for me.

With A1 empty............color

With anything in A1.............no color rows 1:10

I think you should not be looking at Excel as the source of your problem.

Perhaps a video driver issue?


Gord Dibben MS Excel MVP

On Sun, 17 Jun 2007 05:39:00 -0700, johnston
wrote:

Thank you for trying.

Can someone else help?

"Vasant Nanavati" wrote:

Actually, I think it's a screen repainting issue. Not sure what's causing
it.
__________________________________________________ _____________________


"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.

Could the article be applicable?

Only you know for sure.

Are you referring to a UDF? Doesn't appear so.

Try with the shortened version of the formula and see what you get.

Could be Excel is confused by the IF and TRUE, FALSE although as I
said.........worked for me on 2003

I'm not a hardware person so all I can think of is to go to your driver
manufacturer's site and download the latest driver.


Gord


On Sun, 17 Jun 2007 08:39:00 -0700, johnston
wrote:

Thank you for the reply. I also found an article on the Microsoft website
(http://support.microsoft.com/kb/213243/en-us) titled "Odd refresh behavior
after you specify a conditional format in Excel." Could this be applicable?

Any advice on how to check the video driver?

Thanks

"Gord Dibben" wrote:

I can't help other than to say =if($A$1="",TRUE, FALSE) does as it should.

Also =$A$1="" works for me.

With A1 empty............color

With anything in A1.............no color rows 1:10

I think you should not be looking at Excel as the source of your problem.

Perhaps a video driver issue?


Gord Dibben MS Excel MVP

On Sun, 17 Jun 2007 05:39:00 -0700, johnston
wrote:

Thank you for trying.

Can someone else help?

"Vasant Nanavati" wrote:

Actually, I think it's a screen repainting issue. Not sure what's causing
it.
__________________________________________________ _____________________


"johnston" wrote in message
...
I'd appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at
one
time but responded erratically to changes in cell entries. What I did
was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose "Formula is"
*enter =if($A$1="",TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Here's the problem. When I typed into cell A1 a few random letters, some
of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows
is
now correct.