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.
|