View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
 
Posts: 70
Default Coditional Format

Guys, I'm a little unsure how to complete this one. In the example below I
am trying to format cell A1 based on 3 criteria ,,, if cell C1 is less than
80% colour A1 red, if C1 is greater than 80% but less than 90% colour A1
yellow and if C1 is greater than 90% colour A1 green .... the Red and Green I
can get using the Formula Is box in the conditional format function ,, but
how do I get the "between" to work ??


A B C
1 13% 19% 68%