Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel conditional formatting based on multiple conditions?
How can i use the conditional formatting options to format based on multiple requirements?
eg, " person from russia or america, makes over 100,000 a year, and is over the age of 30 "
1 Answer
- 9 years agoFavorite Answer
In your conditional format choose Formula to Determine the format and write:
=AND(OR(B2="Russia",B2="America"),
C2>100000,D2>30)
Where B2 is the country, C2 is the income and D2 is the age.
Of course, you can change the countries, income and ages to input cells that have these values
All on one line, obviously. I ran out of space here.
