Inside the pop-up that seems, around the Formatting tab, move your mouse in excess of the several possibilities to check out a Dwell Preview with your data, and after that click on the formatting option you would like. Conditional formatting generally functions the exact same way in A variety of cells, an Excel desk, or even a PivotTable report.