Conditional Formatting for Each Cell

[aftabn10]

Hi, this might seem a simple question, but cant seem to work it out on Excel 2007! For example the following is a table that shows 2 figures. The first column is an average and the second one is the current weeks figures.

A | B | C
3 | 4 | Queue 1
1 | 1 | Queue 2
7 | 4 | Queue 3
5 | 9 | Queue 4
2 | 1 | Queue 5
1 | 1 | Queue 6

What I would like is to run a conditional formatting for each queues data, so for example if Queue 1s figures on Column B (current week) is greater than the Column A (Average) then this should show in green and if its lower than in red.

Hope that makes sense.

Thanks in advance.

[Marcol]

Maybe this

Highlight your range in column C

Conditional formatting > Use a formula to determine which cells to format

Condition 1
Formula is

=$B2<$A2

Applies to (This is the highlighted range address)
e.g.
=$C$2:$C$7

Format > Red


Condition 2
Formula is

=$B2>$A2

Applies to (This is the highlighted range address)
e.g.
=$C$2:$C$7

Format > Green


Hope this helps

[aftabn10]

Thanks Marcol, what if i needed to higlight the values in Column B? Would this possible?

[Marcol]

Just use the same procedure and formulae, but this time highlight your range in column B instead of C

eg
Applies to
=$B$2:$B$7

P.S.
If you want to format the whole row, highlight your range in columns A to C

Cheers