View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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.