All articles with 'and()' Tag

Many of us use spreadsheets to manage huge lists of data, like customer data bases, salesperson data bases etc. Today we will learn a little conditional formatting trick that you can use to search a worksheet full of data and highlight the matching cells.

Here is a list of formulas I wish MS Excel had. Alas, we need to build some work-arounds to solve them though.