Скачать или смотреть How to change Excel 2007 Cell Color based on value

Learn how to change cell color based on value in Microsoft Excel

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
   / ithowtovids   - our feed
  / howtechtv   - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

In this video we will show you how to change excel cell color based on value.

In order to change excel cell color based on value, open your excel document. Select data in your document. In the "Home" tab, go to "Conditional Formatting" and choose "new rule".

In the following window select "use a formula to determine which cells to format". Edit the rule description, for example, with the next text "=$A4 more than 34". Click "Format".

In the "format cells" window, go to the "Fill" tab, choose a color you like, and then press "ok".

In the "new formatting rule" window press "ok".

Now you know how to change excel cell color based on value.