Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
great, thanks! -- Fedde ------------------------------------------------------------------------ Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
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? -- Fedde ------------------------------------------------------------------------ Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
highlight the cell you want to change colour Formatconditional 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 -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
Ed, thank you very much for your reply! Unfortunately, this is exactly what I did, and still no change of color. Very strange... -- Fedde ------------------------------------------------------------------------ Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
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? -- Fedde ------------------------------------------------------------------------ Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing color of values bigger or smaller than target
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 -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=522530 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing values in a Word Table | New Users to Excel | |||
Count values bigger than cell | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Make Values Smaller Q | Excel Worksheet Functions |