Excel 2010 No Cell Icon
Excel 2007 introduced Icon Sets to Excel Conditional Formatting. Excel 2010 introduces No Cell Icon to Conditional Formatting.
In Excel 2007, after applying your Icon Set Conditional Format, you would get something like this:
Tag: excel
What is the factorial of 0.5 (0.5!)?
If you use Excel and enter the following formula: =FACT(0.5) the answer will be one. However, if you open a more rustic tool such as the Windows Calculator and try again, you will get 0.886226925510.
So, how can a tool such as the Windows calculator come up with the correct answer when Excel can only return 1? What about the factorial of 0.75 (0.75!)? Again, Excel returns 1 whereas the Windows calculator gets the correct answer: 0.919062526898…
Excel 2007: Show image according to chosen name
Here’s a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here’s the solution!
Read more
Excel 2007: Inserting Formulas in a Flash
Here are some nice tricks on how to quickly insert formulas in Excel. Forget all that dragging of the fillhandle and stuff. With these tricks you will be inserting formulas in no time.
Excel 2007: Diagonal Sum
In this tutorial I show you how to sum diagonally using an array formula. You will also learn how to add conditional formatting in order to track the diagonal being summed.
Excel 2007: Highlight Active Row (Take 2 – Part 2)
Here’s a cool way to highlight the active row in Excel (all sheets). This is done using Excel 2007, but it also applies to previous versions of Excel.
Excel 2007: Highlight Active Row (Take 2 – Part 1)
Here’s a cool way to highlight the active row in Excel (all sheets). This is done using Excel 2007, but it also applies to previous versions of Excel.
Excel: How to return names of files located in a folder
In this short tip, I describe how you can return the names of files located in a folder without using VBA.
This is a very neat and easy trick to perform.
Excel 2007: Highlight Active Row
Here’s a cool way to highlight the active row in Excel. This is done using Excel 2007, but it also applies to previous versions of Excel.