How to skip Conditional Formatting for blank Cells

[@beverlyoneill6818]

Thank you!

[@GoldenbanjoDJ]

perfect. thanks

[@SessionsbySaurabh]

Welcome. I’m glad you found it useful.

[@twitchydoo]

I was losing it, thanks for the explanation... It was exactly the error I was running into.

[@SessionsbySaurabh]

You're welcome!

[@Proximian]

Simple and short. Thank you.

[@excelbysaurabh]

Thanks

[@oscarh93]

super useful. thanks!

[@SessionsbySaurabh]

Thanks for appreciating.

[@emachimia]

Thanks, I was really struggling to find a way to make Excel distinguishing between blank cells and cells with zero values!

[@SessionsbySaurabh]

Happy to help and thanks for appreciating.

[@techgrace7]

Amazing. Thanks a lot

[@harshiljain5523]

Awesome. Thanks for sharing...

[@rogersneddon2051]

Absolutely amazing. Thanks very much. Rog

[@SessionsbySaurabh]

Thanks Rog.

[@marqs3lby]

Thank you Sir!

[@Dwavard]

Very useful, thank you 🙂

[@SessionsbySaurabh]

Thanks a lot for your words.

[@enuarora]

Much helpful. 😊

[@SessionsbySaurabh]

Thanks

[@eden4949]

perfect! thanks

[@SessionsbySaurabh]

Thanks

[@jirinazeniskova9877]

It does work for a table. If whole column is formated than Excel makes no diference between 0 and blank cell -> this doesnt work, blank cells are marked as same as 0. Any idea how to simply aply this for whole column? Thx

[@SessionsbySaurabh]

Hi, if you select $B:$B, it will work for a column. Please share what formula are you using and the problem you are facing. I will surely help. Thanks.

[@DVW1983]

Apparently this does not work for cells with drown down selections

[@annettefreeman8671]

Thank you!

[@SessionsbySaurabh]

Thanks for your kind response.