View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Fedde
 
Posts: n/a
Default changing color of values bigger or smaller than target


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