View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marlon Tomera Marlon Tomera is offline
external usenet poster
 
Posts: 1
Default Conditional Formating

If A1-B1 is less than 3, I want cell C1 to turn "Red" and tell me to
"Reorder". And if C1 is greater than 3, I want cell C1 to turn "Green" and
tell me "Do not Order". Does anyone know how to set this formula up? Thanks