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