Conditional Formula

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

really sorry sir , it's doesn't work ---> =HasDate(A1)

 

[Bob Phillips]

does for me.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)