If function Returning Color Cells

Highlighted
Occasional Visitor

I am trying to illustrate year-to-date sales and profit attainment reports by simply using green, yellow or red autofill in cells to illustrate YTD attainment.  I know how to use if statements but I don't have any idea how I would use a three option (Green for meeting YTD goal, Yellow for Slightly Underachieving and Red for Underachieving) function and then autofill the cell with the correct color code.  Thank you.  

1 Reply

@mpayne64 , that is with conditional formatting. You may apply 3 rules, one for each color. For example, for the green with formula like

=YTD>Goal

applying to your cell(s).