• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting - Using Icons with Formulas

J

jdkerr

New Member
Hello. I want to use Icons in Conditional Formatting for a scorecard. The scenario is that we calculate sales forecast accuracy by dividing actual sales by the forecast. So assuming the sales forecast is 100 and the actual sales are 120, the accuracy is 120/100 or 120%. What I want to do is to have a green stoplight icon if the accuracy is between 90% and 110%. A yellow stoplight if it's between 80% and 120% and red beyond those. Does anyone know how to set up a formula that can do that? Thanks!
 
If you check your earlier thread, you'll see responses.

http://chandoo.org/forums/topic/conditional-formatting-question-1
 
You must log in or register to reply here.
Back
Top