Conditional Formatting (if MULTIPLE cells contain ANY text & not numbers)

Okay, do you want the entire area (A1:D10) to change color if ANY of the cells has text and none of the cells have numbers?
or
do you want the individual cell (in the range of A1:D10) to change color if it has text, not a number?

and

when you say, it doesn't have a number, do you mean there's not a stand alone number in the range (i.e. A5= 72)
or
do you mean that the cell with text does not also contain a number (like A5= MG123)?

Try these steps:

1) Using you mouse, select cell A1 in the worksheet.

2) In the Excel Office Ribbon, go to Home > Conditional Formatting > Manage Rules

3) Press "New Rule" and choose "Use a formula to determine which cells to format"

4) Enter this text for the rule: =iserror(1*A1)

5) Press Format button, go to the fill tab, pick your color and press OK.

6) Press OK once more.

7) In Applies To field, use your mouse to select the rest of the range A1:A10, then press enter, then press OK.

Okay, let us know if this doesn't work
Select Cells A1:D10
Conditional Formatting>New Rule>Use Formula...

= ISTEXT(A1) Format > background of appropriate color.
Does that work for you?