troubleshooting Question

Conditional Format Excel 2010

Avatar of Sue Taylor
Sue TaylorFlag for United States of America asked on
Microsoft Excel
10 Comments1 Solution549 ViewsLast Modified:
I'm trying to have a conditional format highlight two cells if one of the two are empty.

In cell B14 I can enter a price per pound
In cell B15 I can enter a price per foot

I have to use either B14 or B15 for calculations in other cells, but I don't need both of them.

 I want both cells to be highlighted if the user left one of them blank.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros