View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TSK TSK is offline
external usenet poster
 
Posts: 21
Default Conditonal Formatting

Can someone advise me how to change the cell color when date is input

I had the following advise formula for text and number but it does not work
with date format

Format == Conditional Formatting
Formula is: =istext(A1)