if not date

  1. L

    Conditional formatting, if not a date

    How do I enter a conditional format to highlight the cell if it's not a valid date? I tried "formula is": =if(not isdate(C10)) <>if(isdate(C10)) Your help would be greatly appreciated!!

Some videos you may like

This Week's Hot Topics

Top