Question

what is the advantage of using conditional formatting

Answer 1

The spreadsheet will have the ability to format itself as you are working on it in real time. This means that anything you do within the spreadsheet will be brought to your attention quicker if the cells were to change their format.

Answer 2

a condition format changes the appearence of cells on the basis of conditions that you specify . if the condirions are true the cell range is formatted , if the conditions are false , the cell range is not formatted