| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing result color
Need help (again)
I have an Excel 2007 worksheet column that contains a calculated average of some daily postings. Is there a way to change the font color of the results when the average exceeds a certain number ? The calculation of the average is fine but I would like to have high results really stand out when the average exceeds 150. Thanks for your help. Gene L. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Changing result color
Home / Styles / Conditional Formatting / New Rule . . . / single left hand
click on:- Format only cells that contain - to highlight it. Change to:- greater than 100 (for example, or the number that you want). Format . . . / Font tab / change the Color: field to the one that you want / OK / OK The above should give you what you want. If my comments have helped please hit Yes. Thanks! "Gene L." wrote: Need help (again) I have an Excel 2007 worksheet column that contains a calculated average of some daily postings. Is there a way to change the font color of the results when the average exceeds a certain number ? The calculation of the average is fine but I would like to have high results really stand out when the average exceeds 150. Thanks for your help. Gene L. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Changing result color
OK I Have it - Great answer - Thank you so much.
Gene L. "trip_to_tokyo" wrote in message ... Home / Styles / Conditional Formatting / New Rule . . . / single left hand click on:- Format only cells that contain - to highlight it. Change to:- greater than 100 (for example, or the number that you want). Format . . . / Font tab / change the Color: field to the one that you want / OK / OK The above should give you what you want. If my comments have helped please hit Yes. Thanks! "Gene L." wrote: Need help (again) I have an Excel 2007 worksheet column that contains a calculated average of some daily postings. Is there a way to change the font color of the results when the average exceeds a certain number ? The calculation of the average is fine but I would like to have high results really stand out when the average exceeds 150. Thanks for your help. Gene L. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing decimal places according to formula result | Excel Discussion (Misc queries) | |||
| changing formulas to their result values | Excel Discussion (Misc queries) | |||
| Changing a cell value in a spreadsheet may not change the result. | Excel Discussion (Misc queries) | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
| Changing color in color palette | Setting up and Configuration of Excel | |||
Linear Mode
