C
Crashcourse Conditional Formatting
I need help with colors in conditional formatting. What I have is a chart
that lists three numbers per line. The lowest of the three numbers need to
turn red, but the problem I keep recieving is 2 of the 3 numbers will go red
with conditional formatting. Example:
A B C
1- 444 456 482
444 should be the only color that goes red, but since I put conditions on
all 3 of the numbers that say if A1 is less than B1 or C1 then turn red, but
my problem runs into when the next line goes as folllows, if B1 is less than
A1 or C1 then turn red. and then finally if C1 is less than A1 or B1 then go
red, which it wont b/c it's higher. How do you make the lowest of all 3 turn
red without more than one turning red? The numbers change daily so this
formula would have to apply to all three colums. Thank you for your help.
that lists three numbers per line. The lowest of the three numbers need to
turn red, but the problem I keep recieving is 2 of the 3 numbers will go red
with conditional formatting. Example:
A B C
1- 444 456 482
444 should be the only color that goes red, but since I put conditions on
all 3 of the numbers that say if A1 is less than B1 or C1 then turn red, but
my problem runs into when the next line goes as folllows, if B1 is less than
A1 or C1 then turn red. and then finally if C1 is less than A1 or B1 then go
red, which it wont b/c it's higher. How do you make the lowest of all 3 turn
red without more than one turning red? The numbers change daily so this
formula would have to apply to all three colums. Thank you for your help.