View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Binglesworth
 
Posts: n/a
Default How do I make an IF statement change cell shading

How do I a make an IF statement change the color of the cell based on the
number inputted? For example I want 0-5 to be clear, 5-10 to be yellow, 10+
to be red. I want to also change the text properties to change the color of
the text. Can either be done?