View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?