I need a conditional formatting formula

Posted on 2014-08-20
Last Modified: 2014-08-20
I am using the following formula in Conditional Formatting:

AND($Q215="APPROVED",$S215="") and it works for what I am trying to do.

Now I need another formula to see if X215 is greater than zero or not blank. I tried to use:

AND($x215="<>",$S215="")  but it shaded my entire range green....

How would I combine the two formulas together. I need it to turn green if q215 says approved OR X215 has a value in it...
Question by:wrt1mea
    LVL 33

    Accepted Solution

    Try this.

    AND(OR($Q215="APPROVED, $X215<>""), $S215="")
    LVL 23

    Expert Comment

    Maybe it should be:


    (if it's not blank, and assuming a number, then it will be greater than 0, so only need the one statement.

    To combine with first formula:

    LVL 1

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    759 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