I don't get your last example... 12 is greater than 11.5 but that is the row
you are highlighting??? Is there rounding going on here???
--
HTH...

Jim Thomlinson


"Derrick" wrote:

im looking to conditionally format a column of numbers to show the 'largest
but not greater than' value in comparison to another cell. that 'largest but
not greater than value' i'd like to change its colour.
the adjacent column, i'd like to format the same as the one adjacent to
it... for example:
1.
A B C D
1 Test Chart
2 12 11 "aaa" "bbb"
3 12 "ccc" "ddd"
4 13 "eee" "fff"

Cells b3,c3,d3 should be changed to green, and the rest normal
2.
A B C D
1 Test Chart
2 14 11 "aaa" "bbb"
3 12 "ccc" "ddd"
4 13 "eee" "fff"

Cells b4,c4,d4 should be green, and the rest normal
3.
A B C D
1 Test Chart
2 11.5 11 "aaa" "bbb"
3 12 "ccc" "ddd"
4 13 "eee" "fff"

Cells b3,c3,d3 should be green, and the rest normal

does this make sense? and if so, is it possible?