1.

Explain Conditional formatting with a help of suitable example.

Answer»

Conditional formatting allows to change the formatting (font color, border, shading) of the cells based on the values in it. One or more cells can be selected, and create rules (conditions) for when and how those cells are formatted. The conditions can be, based on the selected cell's contents, or based on the contents of another cell. 

For example 

Highlight the marks of the students who got marks greater than 80 with green colored text



Discussion

No Comment Found

Related InterviewSolutions