Can a cell change color based on the value of another?
Use conditional formatting in C5 with Condition 1 of Formula Is and a
formula of
=C4C3
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Woodenkettle" wrote in message
...
I would like to have the fill color of one cell change based on the
comparison of values in two other cells. For example, if the number in C4
is
larger than the number in C3 can C5 turn red?
|