test is text, not number..
You probably want something like:
.... NOT(ISNUMBER(A1)) ...
Hope this helps.
Pete
On Jul 14, 1:32 am, nastech wrote:
hi, trying to fix a conditional format to if not empty, but not a number. is
there a way to test for that? along lines of:
=IF(AND(A1<"",A1<number),..
thanks.
|