I need to apply conditional formatting to a column of cells based on the
values in other cells. ex. Cell A2 says $12,876.98 and cell C2 $14,987.98. I
want C2 to be green. The problem is I want to continue the same formatting
for the rest of the column "A3 compared to C3" and so on. If the value in "C"
column is lower I want it highlighted red and if the value is higher I want
it highlighted green.
The values change in each "A" and "C" column and I can only get the
conditional formatting to compare to A2
Any ideas?

Select all the cells in column A that are to have the format ( I will assume
A2 is the first)
Use Format | Conditional Formatting
Specify "Cell value is", "Greater than", in the empty righthand box enter
"=C2" without quotes; and set a format
Use Add
Specify "Cell value is", "Less than", in the empty righthand box enter =C2;
and set a format
Click Ok
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"hamilton_heff" wrote in message
...
I need to apply conditional formatting to a column of cells based on the
values in other cells. ex. Cell A2 says $12,876.98 and cell C2 $14,987.98.
I
want C2 to be green. The problem is I want to continue the same formatting
for the rest of the column "A3 compared to C3" and so on. If the value in
"C"
column is lower I want it highlighted red and if the value is higher I
want
it highlighted green.
The values change in each "A" and "C" column and I can only get the
conditional formatting to compare to A2
Any ideas?

Hi,

To conditionally format your cell(s):

In 2003:
1. Select the cells you want to format (column C)
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=C2<A2
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK one.
8. Click Add
9. For Condition 2, from the first drop down pick Formula is
10. In the second box enter the formula:
=C2A2
11. Click the Format button
1. Choose a color and click OK twice.

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Manage Rules, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=C2<A2
5. Click the Format button and choose a format.
6. Click OK twice
7. New Rule
8. Choose Use a formula to determine which cell to format
9. In the Format values where this formula is true enter the following
formula:
=C2<A2
10. Click the Format button and choose a format.
11. Click OK tree times.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
--

"hamilton_heff" wrote:

I need to apply conditional formatting to a column of cells based on the
values in other cells. ex. Cell A2 says $12,876.98 and cell C2 $14,987.98. I
want C2 to be green. The problem is I want to continue the same formatting
for the rest of the column "A3 compared to C3" and so on. If the value in "C"
column is lower I want it highlighted red and if the value is higher I want
it highlighted green.
The values change in each "A" and "C" column and I can only get the
conditional formatting to compare to A2
Any ideas?