Conditonal Formatting

  • Thread starter Thread starter TSK
  • Start date Start date
T

TSK

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)
 
You can't check specifically for dates, as these are just numbers to
Excel. So, you could have:

Formula Is: =ISNUMBER(A1)

or:

Formula Is: =A1<>""

which will check for non-blanks, but then if the cell is blank it
doesn't matter what the format is !!

Hope this helps.

Pete
 
Back
Top