Conditional Formatting based on adjacent cell value

[MichaelWayne_71]

I have two columns (A and B) and I want B1 to be formatted RED if greater than A1 and GREEN is less than A1. The same should be true for all other rows. (i.e.-B2396 should be compared to A2396...not A1)
...possible?

 

[JoeMo]

I have two columns (A and B) and I want B1 to be formatted RED if greater than A1 and GREEN is less than A1. The same should be true for all other rows. (i.e.-B2396 should be compared to A2396...not A1)
...possible?

1. Select all the cells in column B you want the CF to apply to
2. Use the following formulas (one at a time) to set the CF

=$B1>$A1 (format as red)
=$B1<$A1 (format as green)

 

[ArthriticPanda]

Excel Workbook
	A	B
1	10	12
2	11	5
3	12	6
4	13	22
5	14	12
6	15	15
7	16	2
8	17	19
9	18	6
10	19	7
11	20	21
12	21	34
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Cell Value less than =$A$1	Abc
B1	2. / Cell Value greater than =$A$1	Abc
B2	1. / Cell Value less than =$A$1	Abc
B2	2. / Cell Value greater than =$A$1	Abc
B3	1. / Cell Value less than =$A$1	Abc
B3	2. / Cell Value greater than =$A$1	Abc
B4	1. / Cell Value less than =$A$1	Abc
B4	2. / Cell Value greater than =$A$1	Abc
B5	1. / Cell Value less than =$A$1	Abc
B5	2. / Cell Value greater than =$A$1	Abc
B6	1. / Cell Value less than =$A$1	Abc
B6	2. / Cell Value greater than =$A$1	Abc
B7	1. / Cell Value less than =$A$1	Abc
B7	2. / Cell Value greater than =$A$1	Abc
B8	1. / Cell Value less than =$A$1	Abc
B8	2. / Cell Value greater than =$A$1	Abc
B9	1. / Cell Value less than =$A$1	Abc
B9	2. / Cell Value greater than =$A$1	Abc
B10	1. / Cell Value less than =$A$1	Abc
B10	2. / Cell Value greater than =$A$1	Abc
B11	1. / Cell Value less than =$A$1	Abc
B11	2. / Cell Value greater than =$A$1	Abc
B12	1. / Cell Value less than =$A$1	Abc
B12	2. / Cell Value greater than =$A$1	Abc

AP

 

[Akashwani]

Hi,

Highlight B1 down to your last cell.
For Greater than...
Press, alt H L H G
Type =$A1 into the white box and set your format.

For Less than...
Press, alt H L H L
Type =$A1 into the white box and set your format.

I hope that helps.

Ak

 

[MichaelWayne_71]

ADVERTISEMENT

1. Select all the cells in column B you want the CF to apply to
2. Use the following formulas (one at a time) to set the CF

=$B1>$A1 (format as red)
=$B1<$A1 (format as green)

Does not work for some reason.
is it because there are other formulas in the cell?

 

[JoeMo]

Does not work for some reason.
is it because there are other formulas in the cell?

The formulas do not go in the cells, they are used to specify the conditions. Conditional Formatting/New formatting rule/ use a formula ...

 

[MichaelWayne_71]

Got it...thanks! I used A & B as examples and forgot to change it in my spreadsheet. Actually J & F
Thanks again All!! You all are always a great help