Sometimes you came across missing values or wants to highlight some absent volunteers or students in your worksheet to highlight it and present it to your authority then keep following this space to learn how to highlight it.

This can be used at times when there are a lot of data missing. To understand the same, let’s take an example:

highlight blank values

As you can observe in the image above, we have taken an example of a bunch of students and their totaling of marks scored in every subject.

Previously: Calculate if the value is within tolerance with IF Formula

The blank refers to the student missing that exam I the above example.

highlight blank values

Now let’s begin. The first thing that we will do is input the function of OR.

=OR(

The formula requires logics.

highlight blank values

The first logic in the data is the marks scored in the subject “301”, i.e. 72 marks (cell C4).

highlight blank values

Then we will put an equal to sign with quotation marks having nothing in it, i.e. = “”

Through equal to, we mean we are taking out result and by the empty quotation marks, we mean that if the cell is blank then it should be informed.

highlight blank values

Then we will select the second logic, i.e. the marks scored in subject 302, i.e. 81 marks (cell D4).

highlight blank values

Then again, we will repeat the same thing, i.e. = “”

highlight blank values

Then we will select our third logic. You can add as many logics as you want, it depends on your data.

As we have three subjects, so we will be working on 3 logics. 

So, the third logic is the marks scored in the subject code 303, i.e. 91 marks (cell E4).

highlight blank values

Again, we will repeat the equal to and empty quotation marks sign.

highlight blank values

Then we will close the bracket, which makes our formula complete, i.e.

=OR(C4 = “”, D4 = “”, E4 = “”)

highlight blank values

Then we press enter and the answer comes out as FALSE. This means that there was no missing exam in relation to roll no. 3231.

Now, to find out the answer of other roll nos. in a fast pace, we will drag the formula down which will make our work easier.

(Refer to the image above.)

highlight blank values

Now, we will total the overall marks scored by the roll nos. by using the =SUM( Formula.

highlight blank values

As we know that the SUM Formula requires numbers, so we will select the marks of all three subject codes and we will press enter.

highlight blank values

Here’s the overall marks obtained by each student. 

*you may ignore the warning sign, its there because the SUM is taken out of the values that are adjacent.

highlight blank values

And there you go.

highlight blank values

It’s easy, isn’t it?