Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I highlight certain results in an excel formula?
I have a formula that will bring back data depending on the score that the
formula pulls. I want to have the results in color, for example if the formula pulls back EXCELLENT, I want that in blue. If the formula pulls back HIGH IMPROVEMENT POTENTIAL, I want that in red, etc. Can anyone help????? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I highlight certain results in an excel formula?
See Conditional Formatting in Excel Help
-- Gary''s Student - gsnu201001 "Linda D." wrote: I have a formula that will bring back data depending on the score that the formula pulls. I want to have the results in color, for example if the formula pulls back EXCELLENT, I want that in blue. If the formula pulls back HIGH IMPROVEMENT POTENTIAL, I want that in red, etc. Can anyone help????? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I highlight certain results in an excel formula?
You cannot do it with a formula alone. A formula can only return a value to the cell(s) whence it was called. It cannot modify the properties of the calling cell, or another cell. You can use Conditional Formatting on the Format menu to do this. Select the cell whose value it to be change based on content. Enter "EXCELLENT" in the "Value Is" box, click the Format button, and choose Blue (pattern or font, depending on what you want). Do this same thing for "HIGH IMPROVMENT POTENTIOL". In Excel 2003 and earlier, you can have up to three format conditions. In Excel 2007, the number is unlimited in practical terms. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Tue, 2 Feb 2010 06:51:02 -0800, Linda D. <Linda wrote: I have a formula that will bring back data depending on the score that the formula pulls. I want to have the results in color, for example if the formula pulls back EXCELLENT, I want that in blue. If the formula pulls back HIGH IMPROVEMENT POTENTIAL, I want that in red, etc. Can anyone help????? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating Highlight Results | Excel Worksheet Functions | |||
Cant readliy see the FIND results? Is there a way to highlight bet | Excel Discussion (Misc queries) | |||
Highlight Search Results | Excel Discussion (Misc queries) | |||
Highlight FIND Results | Excel Discussion (Misc queries) | |||
Find and highlight results macro | Excel Programming |