Conditional Formatting Following are the functionalities in conditional formattingHighlight Cell Rules : Highlights the cells Top/Bottom Rules : Top/BottomData Bars : Data BarsColor Scales : Color Icon Sets : Icon sets