View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ericaamousseau ericaamousseau is offline
external usenet poster
 
Posts: 19
Default automatically have cell change color when a number lower than n

Hello, I was wondering if there was a formula that would make the cell change
color if a number or percentage lower than a numebr I choose is in it. For
example if I have a formul to calculate the percentages of say customers
happy, can I make it automatically change ot yellow if the percentage drops
below 80%? Thanks!!