Jul 07 2021 10:57 PM
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.
Jul 07 2021 11:19 PM
SolutionNot 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
Jul 07 2021 11:19 PM
SolutionNot 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