Forum Discussion
If function Returning Color Cells
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).
