Forum Discussion
Helper IIHow to highlight particular row in table?
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.
4 Replies
- Vvelarde
Community Champion
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.
Pitchaimuthucan 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
Hi, accord to my knowledge this is not possible. Conditional Format only works with Numbers.
