changing color of values bigger or smaller than target

[Fedde]

My question:

I need to make a list for keeping track whether employees are of aren'
making their targets, wich looks like this:

SUBJECT[/B] *TARGET*
RESULT
Plaatsingen: 6
5
telefonische afspraken: 8
9
inschrijvingen: 5
5
voorstellen: 7
3
referenties natrekken: 4
5

The first value is the target, second one is the result

Is there a way to change the color of the value of the result
according to the targets? (I want to have them red when under target
and green at target or above.)

Thanks for help in advance!

 

[Chip Pearson]

See Conditional Formatting on the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

in message
news:[email protected]...

 

[Fedde]

great, thanks!

 

[Fedde]

I'm still having a problem with this one.
If I apply the settings in conditional formatting, I don't see any
results what so ever. The cell still does not change color. What am I
doing wrong?

 

[EdMac]

highlight the cell you want to change colour
Format>conditional formatting
Select Cell Value, select Greater than or equal to, click in next box
and then click on the target value.

Select format and then choose the conditions you want to apply if the
condition is met e.g. font colour, background pattern.

Select OK

If you want more than one conditional format, go back to conditional
formatting, select Add and then repeat

hope this helps

Ed

 

[Fedde]

Ed,
thank you very much for your reply!
Unfortunately, this is exactly what I did, and still no change of
color.
Very strange...

 

[Fedde]

Allright, now the color changes, but it also keeps the color when the
value is changed.
For example:
target : 150
If the result is below this value, it turns red. But it stays red even
when the result is above this value, even though I've set the settings
at smaller than...? how can this be?

 

[EdMac]

Hi Fedde,

Does this happen in all the cells or only ones that you have copied the
formatting to?

If it is in the cells that you have copied it to, make sure that the
condition is not referring back to the original cell - you may have got
an absolute reference (with $ signs in it). If this is the case get rid
of the $ signs in the original and then copy down again.

otherwise it should work.

Ed