» Coloring Rows Based on Text Criteria
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
1. Select a cell in the region, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Region.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select Formula Is, and type =$C1="Amazon".
4. Click Format, select the Font tab, select a color, and then click OK.
5. In Condition 2, select Formula Is, and type =$C1="Intel".
6. Repeat step 4, select a different color than you selected for Condition 1, and then click OK.
7. In Condition 3, select Formula Is, and type =$E1="ExcelTip".
8. Repeat step 4, select a different color than you selected for Condition 1 and Condition 2, and then click OK twice.
Note:
Be sure to distinguish between absolute reference and relative reference when entering the formulas.
Book Store:
Recommended Books:
- Microsoft Outlook 2002 for Dummies
- Monte Carlo Methods in Finance
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Microsoft Excel 2002 Simply Visual
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
Mr
Jeff Varol Posted on: 31-12-1969
Does the conditional formatting work for more than 3 Criteria?Blanks
John Morabito Posted on: 31-12-1969
I am trying to highlight data that is outside of the area 0 to 6. I also want it to highlight 0. How do I get it so it doesn't highlight blank cells???
email me: john.morabito@ae.ge.com
In Response to Jeff
Andrew Gail Posted on: 31-12-1969
The built in conditional formatting only allows for 3 sets of criteria.
If you want more you'll need to use VBA.
See here for an example:
http://rhdatasolutions.com/ConditionalFormatVBA/
This may have changed in newer versions of excel though (newer than excel 2000 anyway).
Purchasing Manager
Jon McClain Posted on: 31-12-1969
I need to know if it is possible to use Conditional formatting to compare a long list of competitor pricing in relation to our retail and then highlight the lowest retail of all of our competitors.
Any help would be appreicated.
Email jmcclain@pearison.com
Conditional Formatting Question
Steve Posted on: 31-12-1969
I am trying to create a golf scorecard. I would like to enter the number for each of the 18 holes. Then after playing the course I would enter my score for each hole. I would like to format the cell when I enter my score to change the backgroud color. If I am 1 over par it would change to asy red. If I was 1 under par it would change to green if 2 under par it would change to blue. Can you tell me how to do this in Excel.
Thanks for your help in advance.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
