» 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:
- Adventure Capitalist: The Ultimate Road Trip
- Guide to Financial Reporting and Analysis
- Marketing Management
- Investing for Dummies, Third Edition
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
Format even numbers
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
