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

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

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

"Bob Phillips" wrote:

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

does for me.

--

HTH

Bob Phillips

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

"Tufail" wrote in message
...
really sorry sir , it's doesn't work --- =HasDate(A1)

"Bob Phillips" wrote:

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