LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing values in a Word Table Simon New Users to Excel 0 June 29th 05 10:28 AM
Count values bigger than cell Micos3 Excel Discussion (Misc queries) 5 June 23rd 05 01:16 AM
how do you prevent data from changing values when sorting linked . Cassie Excel Discussion (Misc queries) 0 March 4th 05 10:45 AM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 01:27 PM
Make Values Smaller Q John Excel Worksheet Functions 1 December 14th 04 03:40 PM


All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"