Conditional Formula
You need a UDF
Function HasDate(rng As Range)
HasDate = IsDate(rng.Value)
End Function
and in the CF, use
=HasDate(A1)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Tufail" wrote in message
...
Hello,
I need your help about Conditional Formula.
if A_col has date then i want change the color(any) in B_col.
I think you could understand this.
Thanks/Tufail
|