Conditional Format-Can somone offer the correct syntax

[Fred]

I want to format the background of cell to a10 red if a10 is currently empty
and the length of the string in a5 is 1.

Can somone offer the correct syntax for the conditional format of a10 as
everything I try fails.

Thanks,
Fred

[Bob Phillips]

You need a condition of Formula is and a formula of

=AND(A10="",LEN(A5)=1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fred" <[email protected]> wrote in message
news:[email protected]...
> I want to format the background of cell to a10 red if a10 is currently
empty
> and the length of the string in a5 is 1.
>
> Can somone offer the correct syntax for the conditional format of a10 as
> everything I try fails.
>
> Thanks,
> Fred