Excel 2007 : Formatting the cells on the basis of their values

I am using MS Office 2007. I want to format selected cells in a column that their background changes on entering value in it. For example, I have a sheet containing some data. Now I want that cell A2's colour turns red if a value of it is lower than cell A1, cell A2's colour turns green if its value is greater than A1 and no change appears if both the cells' value is same.

It is possible through Conditional Formatting, But I want to do it in entire row or more than 1 cell at a time which I select. I am attaching how I want the excel to work with cells coloured.

Hello
In your example file, select cells A2:A15, then apply the following conditional formatting formulas:

For Red:
=AND(A2<A1,A2<>"")

For Green:
=A2>A1

Hope this helps.
DBY

Originally Posted by DBY

Hello
In your example file, select cells A2:A15, then apply the following conditional formatting formulas:

For Red:
=AND(A2<A1,A2<>"")

For Green:
=A2>A1

Hope this helps.
DBY

Thanks for your support. But I am not getting it clearly. Can u pls elaborate it. It will be a great help if u can explain it in a bit detail.

Thanks & Regards,

Dhwanit

Hello
No problem. In your example file, select the cell range A2:A15.

Go to Conditional Formatting on the Ribbon.
Select New Rule.
Select Use a formula to determine which cells to format.
In the 'Format values where this formula is true:' enter:

=AND(A2<A1,A2<>"")

Click the Format button to set Format to Red.
Click Ok.

Repeat for Green format with:
=A2>A1

I've also attached an example file for you to look at.

DBY

Originally Posted by DBY

Hello
No problem. In your example file, select the cell range A2:A15.

Go to Conditional Formatting on the Ribbon.
Select New Rule.
Select Use a formula to determine which cells to format.
In the 'Format values where this formula is true:' enter:

=AND(A2<A1,A2<>"")

Click the Format button to set Format to Red.
Click Ok.

Repeat for Green format with:
=A2>A1

I've also attached an example file for you to look at.

DBY

Thanks a lot DBY. Issue is solved. Thanks for your support.

Thanks & Regards,

Dhwanit