If you are working on a spreadsheet and want to be able to quickly see differences in numbers at a glance, you should use the new Conditional Cell Formatting in Excel 2007. Če delate na preglednice in želijo, da bi lahko hitro videli razlike v številkah na prvi pogled, morate uporabiti novo Pogojno oblikovanje celic v Excelu 2007. With this you can change the background of a cell based on the data in the cell, almost like an inline chart. S tem lahko spremenite ozadje celice na podlagi podatkov v celico, skoraj kot inline grafikon.

Using Conditional Formatting Uporaba Pogojno oblikovanje

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. Ko izberete celice, ki jih želite oblikovati, lahko najdete Pogojno oblikovanje spustnem na trak, ki vam daje na kupe vnaprej določiti pravila za izbiro, kot so barvne lestvice.

This will automatically color the items based on the range they are in… To bo samodejno barvo točke na območju so v ...

You can also choose to use icons instead: Izberete lahko tudi, da uporabite namesto ikone:

Reminds me of that commercial… more bars in more places… Spominja me, da so poslovne ... več barov na več mestih ...

You can also create your own rule to color only cells that fit within a certain range, or greater than a certain number. Prav tako lahko ustvarite svoje pravilo, da barvo samo celice, ki ustrezajo v določenem območju, ali višja od določenega števila.

This rule will only color cells greater than a certain amount, with the color you specify. To pravilo se bo le barva celic večje od določenega zneska, z barvo, ki jo določite.

This can be very useful, and you should note that you can apply a second rule to the same range. To je lahko zelo koristen, in vas opozarjamo, da lahko uporabite drugo pravilo na isto območje. For instance, I added a second rule that colored items larger than 2000 with green instead of red. Na primer, sem dodal pravilo, da drugi barvi točke večji kot leta 2000 z zeleno namesto rdeče.

You can even create a completely customized rule by choosing the New Formatting Rule option. Lahko celo ustvarite popolnoma prilagojene praviloma z izbiro New Oblikovanje pravilo možnost.

If you've applied too many rules and want to start over, just select the cells and use the Clear Rules option to remove all the formatting. Če ste se uporablja preveč pravil in želite začeti znova, le da izberete celice in uporabi možnost, jasna pravila, da odstranite vse oblikovanje.

This is one of those really useful features that make Office 2007 a lot better than the prior versions. To je eden od tistih res uporabnih funkcij, ki omogočajo Office 2007 veliko boljša od prejšnje različice.