Changing Color in Cells

J

John Ritz

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
 
D

Dave Peterson

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.
 
P

Paul B

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
 
J

John Ritz

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.
Click to expand...


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!
 
D

Dave Peterson

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.
 
J

John Ritz

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.
Click to expand...


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
 
J

John Ritz

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.
Click to expand...


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.
 
J

John Ritz

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.
Click to expand...


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
 
Top