Using Conditional Cell Formatting In Excel 2007
Using Conditional Formatting Once you select the cells that you want to format, you can find the Conditional Formatting drop-down on the ribbon, which gives you loads of pre-set rules to choose from, like color scales. This will automatically color the items based on the range they are in… You can also choose to use icons instead: Reminds me of that commercial… more bars in more places… You can also create your own rule to color only cells that fit within a certain range, or greater than a certain number....