| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a cell within a percentage range only?
I would like to change the color of a cell based on the percentage in that
cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight a cell within a percentage range only?
format / conditional formatting, use Add for additional conditions
"MoradZ" wrote: I would like to change the color of a cell based on the percentage in that cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight a cell within a percentage range only?
Thanx Marvin, works great! Can I copy + paste just the formatting (with out
coping the formula or data? M "Marvin P. Winterbottom" wrote: format / conditional formatting, use Add for additional conditions "MoradZ" wrote: I would like to change the color of a cell based on the percentage in that cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight a cell within a percentage range only?
Use the format painter if on your toolbar or
copyeditpastespecialsee options -- Don Guillett Microsoft MVP Excel SalesAid Software "MoradZ" wrote in message ... Thanx Marvin, works great! Can I copy + paste just the formatting (with out coping the formula or data? M "Marvin P. Winterbottom" wrote: format / conditional formatting, use Add for additional conditions "MoradZ" wrote: I would like to change the color of a cell based on the percentage in that cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight a cell within a percentage range only?
Hi,
Copy your cell (s) and select Paste Special and select Formats Hope this helps Gav. "MoradZ" wrote: Thanx Marvin, works great! Can I copy + paste just the formatting (with out coping the formula or data? M "Marvin P. Winterbottom" wrote: format / conditional formatting, use Add for additional conditions "MoradZ" wrote: I would like to change the color of a cell based on the percentage in that cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight a cell within a percentage range only?
Duh! Sorry, simple now...
and it's only Mon!!! Thanx "Gav123" wrote: Hi, Copy your cell (s) and select Paste Special and select Formats Hope this helps Gav. "MoradZ" wrote: Thanx Marvin, works great! Can I copy + paste just the formatting (with out coping the formula or data? M "Marvin P. Winterbottom" wrote: format / conditional formatting, use Add for additional conditions "MoradZ" wrote: I would like to change the color of a cell based on the percentage in that cell. Example, 98 - 100% = GREEN. 95 - 98 = Yellow. Is there a formula i can use for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight the cell based on the range for a given value | Excel Discussion (Misc queries) | |||
| VLOOKUP - unable to highlight cell range | Excel Worksheet Functions | |||
| Can't highlight a single cell. Creates a range when I move curso | Excel Worksheet Functions | |||
| highlight range if cell contains desired data | New Users to Excel | |||
| changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
Linear Mode
