Tag: Formatting

  • Filter Cells In Excel With Strike Through Formatting

    I have just finished reviewing an excel spreadsheet where a number of the rows were formatted with strikethough : like this.

    The formatting was valid and the rows have to stay there – but I have no need to review those rows. In excel you can filter rows, by contents or even by colour but not by format.

    Enter a VBA user function:

    (more…)