Forum Discussion

Needsomehelp365's avatar
Needsomehelp365
New Member
3 years ago

Formula for blank cell

I have a massive data set and need to highlight empty cells that have data in the cells (columns) after them. I'm having trouble only highlighting these empty cells and not every empty cell in the range. 

thank you!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Needsomehelp365 ,

    I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

    If you want to specify customized cell colors, please try to apply conditional formatting in tables or matrixes.

    For more details, you can read related document: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_ Binbin Yu