Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way ...

Q. Is there a way to color-code cells based on their cell content? For example, if cells state “Woman-Owned,” could those cells automatically become red and the cells that state “Large Company” ...

On the calendar interface, click the View Settings button in the Current View group. An Advanced View Settings Calendar dialog box will open. Click the Conditional Formatting button. A Conditional ...