Conditional Formatting

T

Tufail

hi,
i am trying to use CF if A1 has date then want change background color of B1
but it doesn't work.

=hasdate(a1)

thanks in advance.
 
Top