Conditional formatting of one cell if it is greater than that of a different cell

[sgcannon]

This should be easy. I just can'f figure out what I'm doing wrong.

I have two columns and I want any cell in the second column to be filled red if it's value is greater than the corresponding cell in the first column.

My conditional formula is: AG1>AD1

And my range is $AG:$AG.

Any thoughts?

Thanks,

Steve

 

[MARK858]

Works for me, are your numbers real numbers and not text (check both columns)? The range is $AG:$AG in reality, just XL2BB is displaying it without the the $

Book1
	AD	AE	AF	AG
1	8			8
2	10			8
3	3			9
4	6			9
5	3			9
6	6			6
7	10			7
8	3			2
9	10			6
10	6			6
11	6			5
12	4			8
13	9			1
14	6			10
15	8			10
16	3			8
17	10			7
18	7			7
19	2			10
20	3			4
21	4			2
22	4			2
23	4			5
24	7			8
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AG:AG	Expression	=AG1>AD1	text	NO

 

[sgcannon]

You are absolutely right. I could have starred at this for 100 years and not figured it out. Thank you!!!!

 

[MARK858]

You're welcome, happy you worked it out