Posted on 2011-10-06
Last Modified: 2012-05-12
I've set up icons to be displayed based upon dates. Green (tomorrow and beyond), yellow
(today), red (date is old). I want to be able to change the red icon to green icon only if the cell
is Q18 is marked complete (selected from a drop down list (Complete, Late, On Track,
Complete / Late).  This is the part of the formula not working.
Question by:nzdeke

    Author Comment

    Look at formula in R18. 0ExcelQuestion.xlsx
    LVL 50

    Expert Comment

    by:barry houdini
    Change the order to check for "Complete" first, i.e.


    regards, barry
    LVL 50

    Accepted Solution

    Sorry, missed closing quotes - should be


    regards, barry

    Author Comment

    Barry - Thank you!!!

    Author Closing Comment

    I worked for 3 days on this and made a stupid mistake. Barry was quick and efficient!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This article may be useful for troubleshooting your PC. Power Supply - no lights or fans running If you have no lights or fans running then either you power is bad, turned off (check switch) or the power supply needs to be replaced. That's a r…
    The viewer will learn how to download, install and use CrashPlan from on Windows 7. Open your browser and go to Click get started, it’s free then Click the Download CrashPlan button: Click save in Internet Explorer, the…
    The viewer will learn how to back up in Windows 7 with native tools. This should be the first step. Third party tools should also be used. Access the Backup and Restore options: Click on the windows 7 start ball in the lower left corner of the scree…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now