I have a spreadsheet used for project management. In one column I have "Deadline Agreed" data, which basically contains a date dd/mm/yy (if agreed with a counterparty) or if a date hasn't been agreed, the cell may be blank or contain text.
I'm looking for a method of conditional formatting this column to highlight any cells where a deadline hasn't been agreed (i.e. the cell is blank or has text in). Would any of you genuises be able to help with this?