Forum Discussion

hopr37 hotmail's avatar
hopr37 hotmail
Brass Contributor
Apr 17, 2018

If cell is blank....

If a cell is blank in any of the cells in column B of a worksheet named "test", how can I fill the blank cells with a word and a different cell color automatically with a formula/macro?

blank cells
Formulas & Functions

3 Replies

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Iron Contributor
    Apr 18, 2018

    Hi hopr37,

     

    Select Entire B Column or Select range ("B1:B1000") or as you like.

     

    In Find & Select - > Go To Special -> Select Blanks -> Click Ok.

     

    Blank cells are now selected. Type the word you want and press Ctrl+Enter.

    Apply the color you want.

    • hopr37 hotmail's avatar
      hopr37 hotmail
      Brass Contributor
      Apr 18, 2018

      Thanks but I'm looking for a formula or macro that does the work automatically.

      • Logaraj Sekar's avatar
        Logaraj Sekar
        Iron Contributor
        Apr 18, 2018

        Hi,

         

        Under Home Ribbon-> Conditional Formatting -> New Rule -> Format only that cell contain -> Choose 'Blanks' from Drop Down Option.

         

        Click 'Format' & Select the Format as you want.

Resources