Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I PROGRAM EXCEL TO HIGHLIGHT A PERCENTAGE THAT IS OVER 90%?
Does anybody know how I can program Excel to highlight a field if I type in a
percentage that is 90% or greater. I use a excel spreadsheet and often plug in percentages but I need to highlight all percentages that are higher than 90%. I usually go to each one and highlight it yellow. Is their a easier way can't excel do this automatically after I type in the percentage? Please help. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I PROGRAM EXCEL TO HIGHLIGHT A PERCENTAGE THAT IS OVER 90%?
Try Conditional formatting:
Assuming the range to be impacted is A2:A100 Select that range. From the Excel Main Menu: <format<conditional formatting Condition_1: Cell value is: Greater than or equal to: 0.9 Click the [format] button and set your highlight color. Click [OK] to complete. Now each value greater than or equal to 90% will be highlighted. Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "ullas9256" wrote in message ... Does anybody know how I can program Excel to highlight a field if I type in a percentage that is 90% or greater. I use a excel spreadsheet and often plug in percentages but I need to highlight all percentages that are higher than 90%. I usually go to each one and highlight it yellow. Is their a easier way can't excel do this automatically after I type in the percentage? Please help. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I PROGRAM EXCEL TO HIGHLIGHT A PERCENTAGE THAT IS OVER 90%?
Use conditional formatting. FormatConditional formatting... Highlight the
cells and choose 'cell value' and 'greater than', then enter .9 in the box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html "ullas9256" wrote in message ... Does anybody know how I can program Excel to highlight a field if I type in a percentage that is 90% or greater. I use a excel spreadsheet and often plug in percentages but I need to highlight all percentages that are higher than 90%. I usually go to each one and highlight it yellow. Is their a easier way can't excel do this automatically after I type in the percentage? Please help. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel program | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Excel program | Excel Discussion (Misc queries) | |||
How do I set up a min max program in excel? | Excel Worksheet Functions |