The instructions for the same are listed below: Launch Microsoft Excel. Select the entire range of columns along with the rows. Apply Conditional Formatting to the selected range of rows and columns.