Conditional formatting using excel 2003

**kthom019** · 11-04-2012, 01:04 PM

I recently reverted to using excel 2003 coming from 2007 and I'm having an issue navigating the conditional formatting in this version. I need to apply a format across rows in a spreadsheet once the condition is met.

Scenario:
In column G, I have a list of numbers stating the current status of each department in my firm
Starting from column H:S are the monthly changes (if any)
In column T I have an average function.

What I wish to accomplish is to format the rows on the sheet based on the condition; if there is a change in column G & S.
Therefore the conditions should be:
1. If column S is greater than column G
2. If column S is less than column G.

Please assist, thanks.

**Norie** · 11-04-2012, 02:14 PM

It's basically the same - you'll have to excuse me if I get any names etc wrong.

Select the rows/columns you want to format.

For the first condition.

Pick the Formula is... option and enter this formula.

=$S2>$G2 - change 2 to reflect the start row

Format as required.

Click Add>>> to add another condition.

For the second condition.

Pick the Formula is... option and enter this formula.

=$S2<$G2 - again, change 2 to reflect start row

Format as required.

**6StringJazzer** · 11-04-2012, 02:26 PM

Welcome to the Forum!

Select the cells in the first row of data that you want to format (it sounds like it's A:T but if not then select whatever columns apply).
Select Format, Conditional Formatting
Set Condition 1 to Use Formula and enter this for the formula:
```
Please Login or Register  to view this content.
```
If you are not starting with row 1, then change the 1 to whatever row number you are using.
Set the format you want to apply for Condition 1.
Add and then set Condition 2 to Use Formula and enter this for the formula:
```
Please Login or Register  to view this content.
```
If you are not starting with row 1, then change the 1 to whatever row number you are using.
Set the format you want to apply for Condition 2.
Click OK.
Click the Format Painter
Highlight the entire range of cells that you want these formats to apply to. This copies the conditional formatting as well as the base formatting.

Attached is a quickie example of how it should look when it's done. [kthom019=conditional formatting in 200.xls]

I hated 2007 conditional formatting until I got the hang of it and now I hate to go back to 2003. CF in 2007+ is a little harder to learn but infinitely more powerful.

**kthom019** · 11-04-2012, 02:29 PM

Thanks Norie

6Stringjazzer, its painful to back. I was just getting comfortable with 2007, then this. Thanks for your help.

**Norie** · 11-04-2012, 03:33 PM

I prefer pre-2007 conditional formatting.

Only drawback was the no of conditions.

There's too many new options with 2007+ CF, I don't think I've ever used some of them.