See Conditional Formatting on the Format menu.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Fedde" wrote
in message
...
My question:
I need to make a list for keeping track whether employees are
of aren't
making their targets, wich looks like this:
SUBJECT[/b] *TARGET*
[b]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 results
according to the targets? (I want to have them red when under
target,
and green at target or above.)
Thanks for help in advance!!
--
Fedde
------------------------------------------------------------------------
Fedde's Profile:
http://www.excelforum.com/member.php...o&userid=30900
View this thread:
http://www.excelforum.com/showthread...hreadid=522530