Conditional format one cell if range contains any text

[coralasiy]

Hi all,

I thought this would be a relatively easy conditional format to apply however i'm really struggling to find a solution.

In brief I would like to apply a conditional format to highlight cell A1, if any of the cells in range, say A2:A100, contain any text. (A2:A100 should only contain dates).

I've tired to apply formatting using variations on formulas containing the istext() function and searched this forum/the internet for a solution but cannot find anything that works to flag one cell if any of the cells in a range contain any text.

Im sure the solution is simple but would appreciate if anyone could give me a hand making this work?

Thank you in advance!

 

[AlanY]

try this CF formula

=COUNT(A2:A100)<99

or if there are blanks within

=COUNT(A2:A100)+COUNTBLANK(A2:A100)<99

 

[steve the fish]

That will only work if all cells have number. Maybe this:

=COUNTIF(A2:A100,"*")