Solved

Combining conditional formatting formula's

Posted on 2016-11-09
1
31 Views
Last Modified: 2016-11-09
How could I combine the following formula's into one formula?  Thanks!!

=$B1<=50%
=NOT(ISBLANK($B1))
0
Comment
Question by:Basssque
1 Comment
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
ID: 41881109
Try this.

=AND($B1<=50%, NOT(ISBLANK($B1)))
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

803 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