Forum Discussion

bramsburg's avatar
bramsburg
Copper Contributor
Jul 13, 2023

Highlight Blank Cells Only In Rows That Contain Data

Hello, we track certain information and my employees sometimes forget/miss filling in some cells. Is there a way that if they start typing in a certain row, any cell that is left blank will turn a color until it is filled in? I have figured out how to highlight blank cells, but it is highlighting all blank cells after the data as well and is making our tracking sheet look sloppy. I'm hoping to figure out how to only highligh

Excel
Formulas and Functions
    • bramsburg's avatar
      bramsburg
      Copper Contributor
      Jul 13, 2023

      Lorenzo You are the best! I'm not sure how it works, but it's working perfectly! Thank you so much!

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jul 14, 2023

        bramsburg 

        Glad this helps. If this can help you understand the following does the same thing:

        =AND(COUNTA($A2:$F2) > 0, ISBLANK(A2))

         

        (At the bottom of each reply you get here there's a way to mark solution - helps those who Search... Thanks)

Resources