How to make numbers change color ?
 

Example:

Using a reference number in a cell like 50. In another cell, if the
number is lower than 50 than it should change to red, if it's higher
than 50, than it shoulf appear green.

How to make this happen automatically ?

Many thanks for the help.

Fernnado


--
fmarques
------------------------------------------------------------------------
fmarques's Profile: http://www.excelforum.com/member.php...o&userid=32150
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Select the cell you're working on and go to FormatConditional
Formatting Then use the conditions and format according to your needs.


--
a7n9


------------------------------------------------------------------------
a7n9's Profile: http://www.excelforum.com/member.php...o&userid=32149
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Hi,

Thanks a lot for the help.

Just one more thing: I have to do this in many cells. When I "copy" and
"paste special" the format it refers to the first cell where I made the
condition.
Do I have to this one by one ?

Thanks again,

Fernando


--
fmarques
------------------------------------------------------------------------
fmarques's Profile: http://www.excelforum.com/member.php...o&userid=32150
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Hilight the range you want to have the conditional format, then do the
same thing


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Hummm... Maybe I'm doing something wrong... But the problem that I have
is:

x x1
y y1
z z1
etc

I need to compare in each line x1 to x, y1 to y, z1 to z and change the
color. there are too many lines. Can I make this format to all at the
same time ?
The conditional format says that I can't choose a range of cells....


--
fmarques
------------------------------------------------------------------------
fmarques's Profile: http://www.excelforum.com/member.php...o&userid=32150
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Hi

Select x1 to z1.
With x1 as active, go to Conditional Formatting and set 'Formula Is' and use
=A3=A2
where x1 is A3
This will replicate the same CF for all three cells.

Hope this helps.
Andy.

"fmarques" wrote in
message ...

Hummm... Maybe I'm doing something wrong... But the problem that I have
is:

x x1
y y1
z z1
etc

I need to compare in each line x1 to x, y1 to y, z1 to z and change the
color. there are too many lines. Can I make this format to all at the
same time ?
The conditional format says that I can't choose a range of cells....


--
fmarques
------------------------------------------------------------------------
fmarques's Profile:
http://www.excelforum.com/member.php...o&userid=32150
View this thread: http://www.excelforum.com/showthread...hreadid=519010

How to make numbers change color ?
 

Or use the Format Brush instead of paste special/format. ed

How to make numbers change color ?
 

Hi,

In a similar vein, I'm having difficulty doing a comparison format.

Data appear as follows:
..........A B C D E F G
Row 1: 1 1 2 1 2 1 1
Row 2: 2 1 2 1 1 2 1

What I want to do is compare row 1 with row 2, and highlight BOTH
values if they are different.

ie. A1 = 1, A2 = 2 -- I want both these values to be formatted to
indicate they are different.
The desired end result here would be to have A1, A2, E1, E2, F1 and F2
formatted.

Suggestions?
Thanks!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=519010