Hide ErrorsYou can use Excel conditional formatting to check for errors, andchange the font colour to match the cell colour. In this example,if column A contains a zero, the #DIV/0! Error is displayed in columnC. Select cells C2:C5. On the Ribbon's Home tab, click Conditional Formatting, then clickNew Rule. Click Use a Formula to Determine Which Cells to Format.

1. Past Words Of The Day
2. Another Word For Past Events

NOTE: In Excel 2003, choose Format Conditional Formatting. Then, from the first dropdown, choose Formula Is. In the rule box, enter a formula that refers to the active cellin the selection. In this example, we selected C2:C5, and cell C2is the active cell, so we'll check for an error in cell C2.=ISERROR(C2)or, to hide only #N/A errors: =ISNA(C2).

Past Words Of The Day

Another Word For Past Events

Click the Format button. Select a font colour to match the cell colour. Click OK, click OKVideo: Hide DuplicateValuesUse Excel conditional formatting to hide duplicate headings on aworksheet, to make a list easier to read. This video shows you thesteps, and the written instructions are below the video.Your browser can't show this frame. Here is a link to the page Hide Duplicate ValuesIn a table, each row should have all data entered, to enable sortingand filtering.