How to make numbers change color ?

[fmarques]

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

 

[a7n9]

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

 

[fmarques]

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

 

[davesexcel]

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

 

[fmarques]

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

 

[Guest]

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.

 

[edcosoft]

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

 

[SlipperyPete]

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!