scalar email

Utilizing Conditional Cell Formatting in Excel 2007

If you are servicing a spread sheet as well as wish to be able to quickly see distinctions in numbers at a look, you need to utilize the new Conditional Cell Formatting in Excel 2007. With this you can change the background of a cell based on the data in the cell, virtually like an inline graph.

Making Use Of Conditional Formatting

Once you select the cells that you want to format, you can locate the Conditional Formatting drop-down on the bow, which provides you tons of pre-set rules to select from, like shade ranges.

This will immediately tint the products based on the variety they are in …

You can likewise select to use symbols instead:

Reminds me of that business … even more bars in more places …

You can also develop your own policy to color just cells that fit within a certain array, or higher than a certain number.

This policy will only shade cells greater than a certain quantity, with the shade you specify.

This can be really helpful, and also you need to keep in mind that you can apply a 2nd policy to the very same array. For example, I included a 2nd policy that colored items larger than 2000 with green as opposed to red.

You can also develop a totally personalized regulation by selecting the New Formatting Rule option.

If you’ve used way too many guidelines and intend to begin again, just select the cells as well as make use of the Clear Rules choice to get rid of all the formatting.

This is one of those truly useful features that make Office 2007 a great deal better than the previous versions.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message