View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
MoradZ MoradZ is offline
external usenet poster
 
Posts: 4
Default 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?