If your spreadsheet contains a lot of data, you can use conditional formatting to highlight values that meet specific criteria. For example, you may want to flag areas in your programming spreadsheet that are smaller than the owner’s required area. Similarly, you could use conditional formatting to highlight spaces that are larger in area than required.