یکشنبه بیست و سوم آذر ۱۳۹۹ - 15:14 - حسين حسين پور -
Highlight blank cells
Generic formula
=ISBLANK(A1)
Summary
To highlight cells that are blank (empty) with conditional formatting, you can use a simple formula based on the ISBLANK function. For example, if you want to highlight blank cells in the range B4:G11, just select the range and create a conditional formatting rule based on this formula:
=ISBLANK(B4)