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