Change color of a cell if another cell has text in it

D

Danielle

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

Dave Peterson

Select D5:E144

With D5 the activecell
format|conditional formating
formula is:
=A5<>""
give it a nice pattern format.

If you really wanted to distinguish only numbers, use a formula like:
=isnumber(a5)
 
Top