Prev: Restrict data entry in a cell
Next: Hlookup with Merged cell as look up value
From: "David Biddulph" groups [at] on 19 Mar 2010 00:57
So if LEN(B1) is 1,it is not blank, so it will satisfy the B1<>"" test, and
the red result is what you'd expect.

What is your formula in B1? Are you sure that you haven't asked it to
produce a space =" " rather than an empty string ="" ?
=CODE(B1) will be 32 if you've got a space in there.
--
David Biddulph


"Nickle" <Nickle(a)discussions.microsoft.com> wrote in message
news:C1487238-2EA3-4652-A8E4-C532C6475A43(a)microsoft.com...
> =LEN(B1) Shows 1
> I do have a cell reference to another spreadsheet. So the outcome on B1
> is
> dependent on what is selected from a cell on the Master sheet.
>
>
>
> "David Biddulph" wrote:
>
>> It shouldn't go red if B1 is blank. Perhaps it is not blank. Perhaps
>> contains one or more spaces? What does =LEN(B1) show?
>> --
>> David Biddulph
>>
>>
>> "Nickle" <Nickle(a)discussions.microsoft.com> wrote in message
>> news:4E508B67-A1D7-4346-A5DF-D1DC04B6E47A(a)microsoft.com...
>> > These two work fine, however my A1 cell turns Red when B1 is blank
>> > which I
>> > was hoping to have no formatting for. Is there another equation that
>> > is
>> > needed. Thank you for the help.
>> >
>> > "Bob Umlas" wrote:
>> >
>> >> With that cell active, use Home/Conditional Formatting, use new Rule,
>> >> use
>> >> Use a formula to determine which cells to format and enter this
>> >> formula:
>> >> =AND(A1<>B1,B1<>"")
>> >> then click format/fill/red
>> >> then do another New Rule and use
>> >> =AND(A1=B1,B1<>"")
>> >> then click format/fill/green.
>> >>
>> >> HTH
>> >> Bob Umlas
>> >> Excel MVP
>> >>
>> >> "Nickle" <Nickle(a)discussions.microsoft.com> wrote in message
>> >> news:75BC19A2-D299-4E2D-B8B1-EAB07D4A2865(a)microsoft.com...
>> >> > I would like a Cell's Text to turn green if A1=B1, but turn red if
>> >> > A1<>B1,
>> >> > and no formatting if B1 is blank. What is the best way to go about
>> >> > this?
>> >> > I
>> >> > have excel2007.
>> >>
>> >> .
>> >>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: Restrict data entry in a cell
Next: Hlookup with Merged cell as look up value