Highlight a cell within a percentage range only?

M

MoradZ

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?
 
M

MoradZ

Thanx Marvin, works great! Can I copy + paste just the formatting (with out
coping the formula or data?

M
 
D

Don Guillett

Use the format painter if on your toolbar or
copy>edit>pastespecial>see options
 
G

Gav123

Hi,


Copy your cell (s)
and select Paste Special and select Formats

Hope this helps

Gav.
 
Top