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

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

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

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

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

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