Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
QianHK
Frequent Visitor

Conditional formatting: mark blank cells between two non-blank cells

Hi all, 

I have a question and please help. 

I would like to fill blank cells between two non-blank cells the same colour, when there are two or more blank cells show together. 

For example, I would like the two blank cells to show red background colour as their neighbouring cells. 

 

conditional format cells between non blank cells.PNG

 

could you help?

 

Thanks!

2 REPLIES 2
mwegener
Most Valuable Professional
Most Valuable Professional

Hi @QianHK ,

 

can you mark the start point with +1 and the end point with -1?

With a running total you could then determine the cells between this values.

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Hi, thanks for your input.

However, I can't change the numbers in cells. They are counts of certain values. If they are not blank,  they are always bigger or equal to 1. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.