Conditional Formula
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 |
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 |
Conditional Formula
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 |
Conditional Formula
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 |
All times are GMT +1. The time now is 05:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com