Select the cells you want to apply conditional formatting. click on home tab on the ribbon and click on conditional formatting in the styles group. choose the type of format you want to apply from the dropdown menu and also elect the formatting rule that you want to apply from the second drop down menu. configure the formatting option for the selected rule. Then click ok to apply the formatting rule to the selected cells.