Question

what is conditional formatting? name any 2 effects that we can apply using conditional formatting

Answer 1

It helps the user to easily separate out data in the colour which he or she wants

One can can apply following using conditional formatting

1). Arranging data in red or blue colour for like that of marks of Students in school

2). No of Holidays taken by the employ during a month