Check to see if any cells in multiple columns are empty.

[epyks23]

I have a couple columns (N, O, P, Q) which hold numbers.
I want to check if any cells in these columns are empty. And if they are, I want Excel to somehow indicate them which ones they are (highlight the cell or the record, preferably). I have a formula in mind.

=IF(OR(ISBLANK(N),ISBLANK(O),ISBLANK(P),ISBLANK(Q),Highlight)

 

[svendiamond]

Go to Conditional Formatting, select "Use a formula to determine which cells to highlight" and enter this formula:

=ISBLANK(N1)

and under "Applies to" enter: =$N:$Q

 

[epyks23]

I do not see the "Applies to". This is what I see:

 

[svendiamond]

After you click "OK" and set your "Format..." to a yellow highlight or something, then go back to Conditional Formatting and click "Manage Rules"

 

[epyks23]

It seems to be highlighting random cells with numbers in them.

This is my process:

What does =ISBLANK(N1) mean? From my understanding, it is asking if cell N1 is blank?

 

[svendiamond]

What does =ISBLANK(N1) mean? From my understanding, it is asking if cell N1 is blank?

Yes. After you click OK on that last screen, check to make sure your formula hasn't changed. Sometimes it glitches and changes to something like "=ISBLANK(N1048576)"