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.

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)





Danielle wrote:

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.

--

Dave Peterson