Home

If function Returning Color Cells

mpayne64
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).

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies