Home
Search:
1146 feeds
357 categories
0 articles (<24 hours)
36 registered users

Use the Mobile version
Mobile

Follow our Twitter feed

View our Linkpartners
Links

Username:
Password:

Register | Retrieve

Technology


RSS FeedsHow to use Microsoft Excel's Conditional Formatting
(PCWorld)

 
 

16 june 2017 16:38:17

 
How to use Microsoft Excel's Conditional Formatting
(PCWorld)
 


Microsoft Excel`s conditional formatting is a wonderful `automatic` feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, you can specify that all the sales totals in your spreadsheet that exceed $5,000 are highlighted in yellow; or all the dates prior to the current year use a dark-green font; or use a shape or ratings icon to flag all duplicate values above 12,000. The options are endless and, in addition to all the preset formats, you can create your own custom formatting rules.The best thing about this feature is that it provides a quick snapshot of your spreadsheet when you view it or show it to others. Because the formatting is based on values, you don`t have to do anything to make it work except update your data.To read this article in full or to leave a comment, please click here


 
16 viewsCategory: Technology > Computer
 
What the Radeon Vega Frontier Edition's specs and pricing mean for PC gamers
(PCWorld)
Aukey's SoundTank Bluetooth speaker is just $33 today
(PCWorld)
 
 
blog comments powered by Disqus


Copyright © 2008 - 2024 Indigonet Services B.V.. Contact: Tim Hulsen. Read here our privacy notice.
Other websites of Indigonet Services B.V.: Nieuws Vacatures Science Tweets Nachrichten