Thread
:
Conditional Formatting
View Single Post
#
2
Posted to microsoft.public.excel.misc
excelent
external usenet poster
Posts: 695
Conditional Formatting
try:
=CELL("format";A1)="D1"
"Tufail" skrev:
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.
Reply With Quote
excelent
View Public Profile
Find all posts by excelent