How to highlight particular row in table?

[Pitchaimuthu]

I have table, it contains the information about the student. Like College_ID, Student_ID, Student_Name, Class. These are the columns in table. so need to highlight the particular row who does not have the College ID. below the table like.

S.No	Collage_ID	Student_ID	Student_Name	Class
1	2601	111450	S. Bala	BE
2	2601	111451	S. Kannan	BE
3	2771	241130	G. Palani	M.com
4		285001	N. Devaraj	M.com
5	2851	311532	G. Anbu	MBA

From this table I need to highlight the 4th row should be red color, why because there is no College ID values. This is what my rquirement. Please give how to do this.

[Vvelarde]

@Pitchaimuthu

Hi, Conditional Formating only work with Numbers Type.

In your case if Collage_ID is a type Number you can apply a Sum and go to Conditional Formating and Select a Format to Blank Values.

[Pitchaimuthu]

can we highlight the string type column?. In our requirements we need to highlight in the row who missed StudentName. below the table.

S.No	College_ID	Student_ID	Student_Name	Class
1	2601	111450	S.Bala	BE
2	2601	111451	S.Kannan	BE
3	2601	111452		M.Com
4	2771	241130	G.Palani	M.com
5		285001	N.Devaraj	MBA
6	2851	311532	G.Anbu	MBA
7	2851	311533		MBA

In this table I need to highlight the 3rd row and 7th row. why because there is no Student Name values. And also I need to highlight and if the user the mouse over on the highlighted column it should be show the "StudentName Missing" message. So please give how to do this?

[Vvelarde]

@Pitchaimuthu

Hi, accord to my knowledge this is not possible. Conditional Format only works with Numbers.

[Pitchaimuthu]

Thanks for your assistance @Vvelarde .