View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Merv Merv is offline
external usenet poster
 
Posts: 5
Default HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS

Automating the result cell to show different colors based on answer of
formula cell. I.E. D1 is result of B1/C1. D1=100% Blue fill; 90% to 99% Green
fill; less than 90% Red fill. This is a corporate dashboard.