Jun 04 2019 11:48 AM
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.
Jun 04 2019 01:35 PM
@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).