» Format even numbers
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
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?
Solution:
Select columns A:B-->Format-->Conditional Formatting-->Enter the following formula in the formula box:
=MOD($A1,2)+MOD($B1,2)=0
Select a desired format and click OK.
Thus, the selected format will apply to rows in column A:B in which both numbers are even. "
List1___List2
2_______4
1_______6
10______7
12______8

Book Store:
Recommended Books:
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Business Plans Kit for Dummies (With CD-ROM)
- Financial Modeling - 2nd Edition
- Accounting Principles, with CD, 6th Edition
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
ed
how to make a formula in excel in this example problem the Code is 223, the last no of code(3) will be the basis of he or she is male or female. for instance (0,2,4,6,8) that is female then ( 1,3,5,7,9) the is male. thanks

