If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

Microsoft Office has a number of comparison operations so you can check if a value is greater than, equal to or less than another value using the standard greater than, less than and equal symbols.

Excel has plenty of built-in functions for calculations, but some of the most useful ones don't crunch numbers at all—they reveal information about your spreadsheet itself. The INFO and CELL functions ...