Conditional Formatting and Blanks
 

I want to conditional format a range of cells. There are many in varied
places that are blank. However, when I apply CF to the cells using a less
that .5, the cell is formatted. I really want that particular cell left
alone. How do I tell Excel to leave the blanks alone?
--
Thanks As Always
Rip

Conditional Formatting and Blanks
 

Use formula is and

=AND(A1<"",A1<0.5)

--


Regards,


Peo Sjoblom

"Ripper" wrote in message
...
I want to conditional format a range of cells. There are many in varied
places that are blank. However, when I apply CF to the cells using a less
that .5, the cell is formatted. I really want that particular cell left
alone. How do I tell Excel to leave the blanks alone?
--
Thanks As Always
Rip

Conditional Formatting and Blanks
 

Try this:

=AND(B1<5,B1<0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ripper" wrote in message
...
I want to conditional format a range of cells. There are many in varied
places that are blank. However, when I apply CF to the cells using a less
that .5, the cell is formatted. I really want that particular cell left
alone. How do I tell Excel to leave the blanks alone?
--
Thanks As Always
Rip

Conditional Formatting and Blanks
 

Your eyes must be younger then mine!<g

I didn't see that decimal.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
Use formula is and

=AND(A1<"",A1<0.5)

--


Regards,


Peo Sjoblom

"Ripper" wrote in message
...
I want to conditional format a range of cells. There are many in varied
places that are blank. However, when I apply CF to the cells using a
less
that .5, the cell is formatted. I really want that particular cell left
alone. How do I tell Excel to leave the blanks alone?
--
Thanks As Always
Rip