For our address label printer we use an Excel file. Unfortunately in Holland many people forget to add their house number and I'm trying to fill them with red so our team knows they need to contact them to get their house number.

Here is an example:

(The G3 in the formula refers to the top left cell.)

CodePudding user response：

To find if string contains any number you can use this formula:

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},D1))>0

It returns TRUE if there is a number and FALSE otherwise.

Since you can't use arrays in conditional formatting you have to use this formula in "helper column", then you can use output (TRUE and FALSE) in conditional formatting.