Conditional Formatting and Blanks

[Ripper]

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?

 

[Peo Sjoblom]

Use formula is and

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

--


Regards,


Peo Sjoblom

 

[RagDyer]

Try this:

=AND(B1<5,B1<>0)

 

[RagDyer]

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 !
---------------------------------------------------------------------------

Use formula is and

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

--


Regards,


Peo Sjoblom