Format even numbers

Problem: Column A:B contain two lists of numbers. How could we create a formula that will indicate rows in which both of the numbers are even? ...

how to Use the Round Function to Round Numbers to Thousands in Excel

While playing with big numbers, all digits of an number doesn’t matter that much and we can ignore them to make it more readable relatable. For exam...

Inserting Special Symbols into Custom Formats

To insert a symbol into a new number format in Excel 97 & Excel 2000: Example: Create and save a number format with the € (euro) symbol. 1...

Add special symbols to the number format

Add special symbols to the number format, such as symbols that are not included in the currency or accounting formats. The CHAR formula displays the...

Coloring Even Numbered Rows in a List

To color even numbered rows: 1. Select a cell in the region and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Regi...

Applying Colors to Maximum/Minimum Values in a List

To apply colors to maximum and/or minimum values: 1. Select a cell in the region, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to s...

Displaying Figures in Financial Reports Rounded to Thousands

By easily changing the Style in the Style box, you can quickly change the presentation of numbers in any report. For example, display and print report...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube