Conditional Format Question

[banker123]

I have a column that makes up the net change between two other columns. I would like to put in a conditional format that does the following:

1) Any cell in this column unchanged (a value of 0) will be one color
2) Any cell in this column greater than 0 will be a different color

I'm new to conditional formats so any help would be greatly appreciated.

Thanks in advance.

[Tony Valko]

Try this...

Let's assume the range of interest is A2:A10

Select the *entire* range A2:A10 starting from cell A2.
Cell A2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=COUNT(A2)*(A2=0)

Click the Format button
Select the desired style(s)
OK>OK>New rule>Use a formula to determine which cells to format

Enter this formula in the box below:

=COUNT(A2)*(A2>0)

Click the Format button
Select the desired style(s)
OK out

[banker123]

Thank you very much. It worked perfectly.

[rgs694]

You can select this third column that calculates the difference between the first two columns, and set up two separate conditional formats from there. For the first one you want equal to zero, go to "Conditional Formatting>New Rule>Format Cells That Contain>Equal To>0>select your format". Leave the column highlighted, then go to "Conditional Formatting>New Rule>Format Cells That Contain>Greater than>0>select your format".

[Tony Valko]

You're welcome. Thanks for the feedback!

[TMS]

@Biff: what's the advantage of using those formulae as opposed to a simple cell value check (equal/not equal to 0)?

Regards, TMS

[Tony Valko]

Don't know if there's an advantage or not.

In all the years I've been using Excel I have never used the selectable rules.

I've only used formulas to define the rules.

Why? I don't know why!