Checking for just spaces

[Brad]

In conditionally formating I want to check if the cell has just spaces

I used the following logic

if the length of the cell is greater than zero (multiply) if the length of
the trimmed cell = 0. if both of these conditions are true - turn the cell
red - otherwise leave alone. This works - however is there an easier way to
do this?

[Barb Reinhardt]

Try this is your conditional format

=AND(LEN(B15)>0,LEN(TRIM(B15))=0)

I selected B15 and put a couple of spaces in it.


"Brad" wrote:

> In conditionally formating I want to check if the cell has just spaces
>
> I used the following logic
>
> if the length of the cell is greater than zero (multiply) if the length of
> the trimmed cell = 0. if both of these conditions are true - turn the cell
> red - otherwise leave alone. This works - however is there an easier way to
> do this?

[Dave Peterson]

Or (dropping the len() bit):

=AND(LEN(B15)>0,TRIM(B15)="")



Barb Reinhardt wrote:
>
> Try this is your conditional format
>
> =AND(LEN(B15)>0,LEN(TRIM(B15))=0)
>
> I selected B15 and put a couple of spaces in it.
>
> "Brad" wrote:
>
> > In conditionally formating I want to check if the cell has just spaces
> >
> > I used the following logic
> >
> > if the length of the cell is greater than zero (multiply) if the length of
> > the trimmed cell = 0. if both of these conditions are true - turn the cell
> > red - otherwise leave alone. This works - however is there an easier way to
> > do this?

--

Dave Peterson

[Brad]

Barb,

Thanks - That works and is essentially what I did - I compared the
=(AND(LEN(B15)>0,LEN(TRIM(B15))=0)*1)=1 - your way is slightly easier.
However, is there an easier way of doing this??


"Barb Reinhardt" wrote:

> Try this is your conditional format
>
> =AND(LEN(B15)>0,LEN(TRIM(B15))=0)
>
> I selected B15 and put a couple of spaces in it.
>
>
> "Brad" wrote:
>
> > In conditionally formating I want to check if the cell has just spaces
> >
> > I used the following logic
> >
> > if the length of the cell is greater than zero (multiply) if the length of
> > the trimmed cell = 0. if both of these conditions are true - turn the cell
> > red - otherwise leave alone. This works - however is there an easier way to
> > do this?