Conditional Format?
 

Excel 2000 ... I know this is basic ... However, I always
have a "brain cramp" when dealing with ... "Empty Cells
&/or Blank Cells"

I want to set Conditional Formatting in Cell A2 to turn
Cell pattern "Green" whenever Cell B2 is EMPTY or NOT
BLANK.

What is the Contional Formatting Formula for this???

Hopefully, I will know how to get Conditional Formatting
where I want it once I have the answer to above ... :)

Thanks ... Kha

Isn't that gonna mean that the conditional formatting will be applied all the
time.

When would you want the cell not to be green?

Ken wrote:

Excel 2000 ... I know this is basic ... However, I always
have a "brain cramp" when dealing with ... "Empty Cells
&/or Blank Cells"

I want to set Conditional Formatting in Cell A2 to turn
Cell pattern "Green" whenever Cell B2 is EMPTY or NOT
BLANK.

What is the Contional Formatting Formula for this???

Hopefully, I will know how to get Conditional Formatting
where I want it once I have the answer to above ... :)

Thanks ... Kha

--

Dave Peterson

Dave ...

A cell can be "Empty" or it can "appear empty" (spaces,
etc" ... The "conditional formatting" I am using is
presently turning off for "Empty" cells (this is good),
but it is turning on for cells "appearing empty" (I am
assuming spaces ... & this is not good ... Once I "clear"
or "delete" cell contents from cells "appearing empty"
then "conditional formatting" works fine.

Now back to original post ... Maybe I can clarify ... If
cell contents are "visible" then apply "conditional
formatting".

Thanks ... Kha


-----Original Message-----
Isn't that gonna mean that the conditional formatting
will be applied all the
time.

When would you want the cell not to be green?

Ken wrote:

Excel 2000 ... I know this is basic ... However, I
always
have a "brain cramp" when dealing with ... "Empty Cells
&/or Blank Cells"

I want to set Conditional Formatting in Cell A2 to turn
Cell pattern "Green" whenever Cell B2 is EMPTY or NOT
BLANK.

What is the Contional Formatting Formula for this???

Hopefully, I will know how to get Conditional Formatting
where I want it once I have the answer to above ... :)

Thanks ... Kha

--

Dave Peterson
.

Maybe you're looking for the =isblank() function???

or
=len(a1)0

or
=len(trim(a1))0




Ken wrote:

Dave ...

A cell can be "Empty" or it can "appear empty" (spaces,
etc" ... The "conditional formatting" I am using is
presently turning off for "Empty" cells (this is good),
but it is turning on for cells "appearing empty" (I am
assuming spaces ... & this is not good ... Once I "clear"
or "delete" cell contents from cells "appearing empty"
then "conditional formatting" works fine.

Now back to original post ... Maybe I can clarify ... If
cell contents are "visible" then apply "conditional
formatting".

Thanks ... Kha

-----Original Message-----
Isn't that gonna mean that the conditional formatting
will be applied all the
time.

When would you want the cell not to be green?

Ken wrote:

Excel 2000 ... I know this is basic ... However, I
always
have a "brain cramp" when dealing with ... "Empty Cells
&/or Blank Cells"

I want to set Conditional Formatting in Cell A2 to turn
Cell pattern "Green" whenever Cell B2 is EMPTY or NOT
BLANK.

What is the Contional Formatting Formula for this???

Hopefully, I will know how to get Conditional Formatting
where I want it once I have the answer to above ... :)

Thanks ... Kha

--

Dave Peterson
.


--

Dave Peterson