» 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:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The Fall of Advertising and the Rise of PR
- Special Edition Using Microsoft Outlook 2002
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Personal Finance for Dummies
- Windows XP for Dummies
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
