In the drop-down box, select Formula Is.Click Format -> Conditional Formatting.Select the range of cells you wish to format.Here’s how you can use it to apply shading to alternate rows: Conditional formatting lets you apply formatting based on the value contained in a cell or based on the result of a formula. The solution? Do the job yourself, using conditional formatting. Yes, there’s one auto-format option which gives you this – sort of – but it comes with unattractive headings and footer formatting and it’s inflexible. Who designed these things? Not only are they ugly, they also don’t address basic formatting needs such as coloring every other row in order to make a table more readable. Take, for example, the auto-formats supplied with pre-2007 versions of Excel. This thought often crosses my mind when working with Office sample files, templates and styles. I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |