condionally formatting based on another cells formatting?
 

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?

condionally formatting based on another cells formatting?
 

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?

condionally formatting based on another cells formatting?
 

yes. because stress levels are can be higher (and therefore more risky) to
play safe, longer distances are gonna be used to get lower numbers...
so. if if 11.5 is input, 12 is used because it is longer. if 12 is input,
then use 12 because its exact. ... this just means my previous examples are
wrong. sorry. if 14 is picked, then the smallest number should be 14, not 13
if 12 is imput, then 12 is used.
if 12.4 is input, use 13.

so use smallest but not less than.. not largest but not greater than
thanks for catching that. can u help?
"Jim Thomlinson" wrote:

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?