We help IT Professionals succeed at work.
Get Started
How do I do conditional formatting in Excel for cells where Length = 0?
I am doing a spreadsheet comparing each month's revenue to the month before it. I have no problem setting the formatting if the revenue has increased or decreased. My problem is with the cells where the values haven't been calculated yet. (info coming in the future) Since there is a formula calculating this cell, I think that I have to check for Length = 0. I don't know how to set this up from the "Conditional Formatting" button in Excel 2016. (Please note that I do NOT want to use any VBA macros for this unless absolutely necessary. I would prefer to just use the application's conditional formatting tool.) I have tried using: =Length(B5) = 0 and Length(B5) = 0 but don't get any results. Thanks for the help.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE