View Single Post
  #1   Report Post  
Danielle
 
Posts: n/a
Default Change color of a cell if another cell has text in it

I am trying to achieve this:

If i have text in range a5:b144 then I want to color each coresponding cell
in the range d5:e144.

ie: if a5 has a number in it... then d5 turns yello
ie: if b33 has a number in it.. then e33 turns yello

Is there a way to do this?

D.