Is there an easy way to make a cell content change to a certain color?

For example if you input say $2.00 into a cell can you have it
automatically become green?

Can you do the same thing with the background color?

Thanks

Depends on how many rules you have and what version of excel you're using.

If you're using xl2003 or below, and only have 3 rules (plus the normal look),
you can use format|conditional formatting.

The limit was increased in xl2007.

John Ritz wrote:
>
> Is there an easy way to make a cell content change to a certain color?
>
> For example if you input say $2.00 into a cell can you have it
> automatically become green?
>
> Can you do the same thing with the background color?
>
> Thanks

--

Dave Peterson

john, have a look at conditional formatting, format, conditional formatting

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"John Ritz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there an easy way to make a cell content change to a certain color?
>
> For example if you input say $2.00 into a cell can you have it
> automatically become green?
>
> Can you do the same thing with the background color?
>
> Thanks

On Thu, 22 Mar 2007 05:59:41 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>Depends on how many rules you have and what version of excel you're using.
>
>If you're using xl2003 or below, and only have 3 rules (plus the normal look),
>you can use format|conditional formatting.
>
>The limit was increased in xl2007.
>
>John Ritz wrote:
>>
>> Is there an easy way to make a cell content change to a certain color?
>>
>> For example if you input say $2.00 into a cell can you have it
>> automatically become green?
>>
>> Can you do the same thing with the background color?
>>
>> Thanks


OK. So far so good. I turned the cells with a value of greater than
$2.00 to green and those with a value of less than $2.00 to red.

However, I did this by grabbing four of five columns across the top
and now every other cell down to the bottom of the page (infinity?) is
red. Is there way I can keep cells with no data white? I tried
several combinations, but nothing worked.

Thanks!

Can you enter a 0 or negative numbers in that range?

If no, you can change your rule to greater than 0 and less than 2.

If yes, then you can use:
formula is:
=AND(G1<>"",G1<2)

G1 was my activecell in my selection.

John Ritz wrote:
>
> On Thu, 22 Mar 2007 05:59:41 -0500, Dave Peterson
> <(E-Mail Removed)> wrote:
>
> >Depends on how many rules you have and what version of excel you're using.
> >
> >If you're using xl2003 or below, and only have 3 rules (plus the normal look),
> >you can use format|conditional formatting.
> >
> >The limit was increased in xl2007.
> >
> >John Ritz wrote:
> >>
> >> Is there an easy way to make a cell content change to a certain color?
> >>
> >> For example if you input say $2.00 into a cell can you have it
> >> automatically become green?
> >>
> >> Can you do the same thing with the background color?
> >>
> >> Thanks
>
> OK. So far so good. I turned the cells with a value of greater than
> $2.00 to green and those with a value of less than $2.00 to red.
>
> However, I did this by grabbing four of five columns across the top
> and now every other cell down to the bottom of the page (infinity?) is
> red. Is there way I can keep cells with no data white? I tried
> several combinations, but nothing worked.
>
> Thanks!

--

Dave Peterson

On Thu, 22 Mar 2007 14:55:57 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>Can you enter a 0 or negative numbers in that range?
>
>If no, you can change your rule to greater than 0 and less than 2.
>
>If yes, then you can use:
>formula is:
>=AND(G1<>"",G1<2)
>
>G1 was my activecell in my selection.
>
>John Ritz wrote:
>>
>> On Thu, 22 Mar 2007 05:59:41 -0500, Dave Peterson
>> <(E-Mail Removed)> wrote:
>>
>> >Depends on how many rules you have and what version of excel you're using.
>> >
>> >If you're using xl2003 or below, and only have 3 rules (plus the normal look),
>> >you can use format|conditional formatting.
>> >
>> >The limit was increased in xl2007.
>> >
>> >John Ritz wrote:
>> >>
>> >> Is there an easy way to make a cell content change to a certain color?
>> >>
>> >> For example if you input say $2.00 into a cell can you have it
>> >> automatically become green?
>> >>
>> >> Can you do the same thing with the background color?
>> >>
>> >> Thanks
>>
>> OK. So far so good. I turned the cells with a value of greater than
>> $2.00 to green and those with a value of less than $2.00 to red.
>>
>> However, I did this by grabbing four of five columns across the top
>> and now every other cell down to the bottom of the page (infinity?) is
>> red. Is there way I can keep cells with no data white? I tried
>> several combinations, but nothing worked.
>>
>> Thanks!


I'm using Office 2000, if that makes a difference.

I don't have any formulas in the range. I'm just inputing the numbers
by hand. I don't know if that makes a difference either, but I'm
guessing it does.

Thanks

On Thu, 22 Mar 2007 14:55:57 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>Can you enter a 0 or negative numbers in that range?
>
>If no, you can change your rule to greater than 0 and less than 2.
>
>If yes, then you can use:
>formula is:
>=AND(G1<>"",G1<2)
>
>G1 was my activecell in my selection.
>
>John Ritz wrote:
>>
>> On Thu, 22 Mar 2007 05:59:41 -0500, Dave Peterson
>> <(E-Mail Removed)> wrote:
>>
>> >Depends on how many rules you have and what version of excel you're using.
>> >
>> >If you're using xl2003 or below, and only have 3 rules (plus the normal look),
>> >you can use format|conditional formatting.
>> >
>> >The limit was increased in xl2007.
>> >
>> >John Ritz wrote:
>> >>
>> >> Is there an easy way to make a cell content change to a certain color?
>> >>
>> >> For example if you input say $2.00 into a cell can you have it
>> >> automatically become green?
>> >>
>> >> Can you do the same thing with the background color?
>> >>
>> >> Thanks
>>
>> OK. So far so good. I turned the cells with a value of greater than
>> $2.00 to green and those with a value of less than $2.00 to red.
>>
>> However, I did this by grabbing four of five columns across the top
>> and now every other cell down to the bottom of the page (infinity?) is
>> red. Is there way I can keep cells with no data white? I tried
>> several combinations, but nothing worked.
>>
>> Thanks!


OK. I fixed it by inputing >if cell value is less than or equal to
$1.99.<

However there is something curious. In the first condition, where I
have it turn green if it is greater than $2.00 it does a color fill.

In the second condition where I have it turn red it turns the font
red--no fill.

I wanted both to fill, and I did them both exactly the same, but I got
two different styles.

What am I missing?

Thanks again.

On Thu, 22 Mar 2007 05:59:41 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>Depends on how many rules you have and what version of excel you're using.
>
>If you're using xl2003 or below, and only have 3 rules (plus the normal look),
>you can use format|conditional formatting.
>
>The limit was increased in xl2007.
>
>John Ritz wrote:
>>
>> Is there an easy way to make a cell content change to a certain color?
>>
>> For example if you input say $2.00 into a cell can you have it
>> automatically become green?
>>
>> Can you do the same thing with the background color?
>>
>> Thanks


I got it working now. I had to use two rules to get it to do the red
thing.

Thanks for pointing me in the right direction.

John