Forum Discussion

HelpGeorge's avatar
HelpGeorge
Copper Contributor
Jul 08, 2021
Solved

Multiple Rows with Blank Cells

Hi I am wondering if there is a way to ONLY highlight cells that are blank in multiple rows?

 

I have some raw data that has multiple rows and columns and I want to check which are blank across multiple fields of information.

BI & Data Analysis
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jul 08, 2021

    HiHelpGeorge 

    Not sure what you exactly want, so 2 options:

     

    If the Yellow: Select B2:D7 > Cond. Format. > New rule > Use a formula to determine...:

    =COUNTBLANK($B2:$D2)=3

     

    If the Green: Select G2:I7 > Cond. Format. > New rule > Format only cells that contain > In list Format only cells with choose Blanks

     

     

     

     

     

3 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 08, 2021

    HiHelpGeorge 

    Not sure what you exactly want, so 2 options:

     

    If the Yellow: Select B2:D7 > Cond. Format. > New rule > Use a formula to determine...:

    =COUNTBLANK($B2:$D2)=3

     

    If the Green: Select G2:I7 > Cond. Format. > New rule > Format only cells that contain > In list Format only cells with choose Blanks

     

     

     

     

     

Resources