Prev: Restrict data entry in a cell
Next: Hlookup with Merged cell as look up value
From: Nickle on 18 Mar 2010 15:51
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.
From: Bob Umlas on 18 Mar 2010 16:29
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.

From: Nickle on 18 Mar 2010 17:49
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.
>
> .
>
From: "David Biddulph" groups [at] on 18 Mar 2010 18:24
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.
>>
>> .
>>

From: Nickle on 18 Mar 2010 20:04
=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.
> >>
> >> .
> >>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Restrict data entry in a cell
Next: Hlookup with Merged cell as look up value