Share via

Identifying blank cells

Anonymous
2024-09-27T16:28:09+00:00

In conditional formatting, how do I identify cells that are blank to contain a specific formatting, i.e. I want to highlight all blank cells in a column?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-27T18:50:39+00:00

    Dear respected Al Christenson2,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, to highlight blank cells in a column using Conditional Formatting in Excel, click on the header of the column where you want to identify blank cells (for example, Column A). This will select the entire column. In Conditional Formatting> Use a formula to determine which cells to format, enter the following

    =ISBLANK(A1)

    If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

    Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

    I'm sorry and I apologize for that.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    0 comments