Thread: Highlight a cell within a percentage range only?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom Marvin P. Winterbottom is offline
external usenet poster
  
Posts: 34
Default 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?
Reply With QuoteReply With Quote