View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default CONDITIONAL FORMAT

I need to use three colors with multiple conditions;
green = 5.6-6.0 or 6.1-7.0
Yellow= <700 or 900
Red= 1.1-3.8 or 2.0-5.9 or 5.0-6.9
They are in rows; B12 and row C13 and rowD14.
I'm ok with the cells, but not formulas. I appreciate you in advance!

Thanks, Heat.