[Last Call] Learn how to a build a cloud-first strategyRegister Now


I need a conditional formatting formula

Posted on 2014-08-20
Medium Priority
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 35

Accepted Solution

Norie earned 2000 total points
ID: 40273432
Try this.

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

Expert Comment

ID: 40273434
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:


Author Closing Comment

ID: 40273602

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

831 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