With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

Launch Microsoft Excel. Select the entire range of columns along with the rows. Apply Conditional Formatting to the selected range of rows and columns. Click OK. Let’s see the above steps in ...