Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Nov 6, 2:30 pm, jpmurray22
wrote: I am working with a spreadsheet that is based on percetnages. Is there a way that I can select the entire page (or just certain rows and columns) and have excel somehow highlight or color the cells that are above a certain percentage?? I wonder if Condition Formatting solves your problem. Select one or more cells, click on Format = Conditional Formatting, select "greater than" in the middle pull- down menu, fill in 50% in the right-most field, click on Format = Patterns, and select your favorite color. HTH. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
percentages | Excel Worksheet Functions | |||
percentages | Excel Worksheet Functions | |||
PERCENTAGES | Excel Worksheet Functions | |||
Percentages | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |