Home > Net >  Excel: How to Format / Highlight cells that DO NOT contain any number
Excel: How to Format / Highlight cells that DO NOT contain any number

Time:12-09

For our address label printer we use an excel file. unfortunately in holland many people forget to add there house # and i im trying to fill them with Red so our team knows they need to contact them to get their house number.

Heer is an example: enter image description here

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

  • Related