Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Excel 2010 - Conditional Formatting

Posted on 2010-08-17
Medium Priority
858 Views
I have a spreadsheet that contains a number of columns and cells. I wish to make on of the cells subject to a conditional format. If the value of AA2 is greater than the value of E2 then make F2 Green, if it less make it red and if it equals do nothing.

I know this is a simple task but I can't for the life of me work out how to do more than one conditional format to a cell.

And I have ordered a dummies guide to Excel & VBA for those of you who are tired of answering my questions :)
0
Question by:NorthstarIT
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 8

Assisted Solution

McNetic earned 400 total points
ID: 33452681
In Excel until 2003 (I believe), the conditional formatting dialog has button "Add >>" or somethink like this on the bottom, which adds a new line of conditional formatting, for up to 3 total.
In Excel from 2007, you can do "Conditional formatting'->New Rule to add new rules. I don't know if there's a limit.
0

LVL 8

Assisted Solution

ID: 33452727
In Excel 2010 perform your conditonal formatting for "greater than" then do it again for "less than"

The second rule doesn't oevrwite the first one, it coexists.
0

LVL 1

Accepted Solution

Verbert earned 1200 total points
ID: 33452743
In Excel 2010 it goes as follows :
- Select the cell(s) that you want to format
- Create a new rule
- Select the 'Use a formula' option in the type list
- Type in the formula : =A1 < A2 for example
- Set the format as you wish

The repeat the previous steps, but alter the formula to =A1 > A2 and change the format.

That should do it!
0

Author Closing Comment

ID: 33452850
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month11 days, 10 hours left to enroll