Highlight a cell within a percentage range only?

  • Thread starter Thread starter MoradZ
  • Start date Start date
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?
 
format / conditional formatting, use Add for additional conditions
 
Thanx Marvin, works great! Can I copy + paste just the formatting (with out
coping the formula or data?

M
 
Use the format painter if on your toolbar or
copy>edit>pastespecial>see options
 
Hi,


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

Hope this helps

Gav.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
IF formula with conditional formating help please 3
Partial Shading in Excel 2003 4
Setting an Icon Set conditional format for a single cell??? 4
automatically have cell change color when a number lower than n 2
IF statement Help 10
Return a number from a list of date ranges 1
Percentages to include changing cell's color 1

Back
Top