View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tan Nico Tan Nico is offline
external usenet poster
 
Posts: 1
Default Insert data with length between 11 OR 15 digits

Hi,

I want to create the formula than can calculate the Length of cell is 11 or
15 dig (in one formula only), and the blank cell (null) is doesn't count for.

I preffered the formula to be inserted ini Conditional Formula, and if
there's any cell that contain data not 11 or 15 dig, it's cell gonna have a
red background (ps. the blank cell also not to be count, cause I want to copy
to single coloumn)

If anyone could help me on this formula, before thank you first to you.

Thanx. Nico.