Apr 04 2019 02:11 AM
Hi all,
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?
Many thanks,
Roxo
Apr 04 2019 02:58 AM - edited Apr 04 2019 02:59 AM
SolutionSelect the cells you want to conditionally format and enter this conditional formatting formula:
=NOT(ISNUMBER(A2))
The foregoing formula assumes that your dates start in A2.
Apr 04 2019 03:07 AM
Perfect just tried this and its worked :) Maybe wasn't that challenging after all!
Thanks for your help!!
Apr 04 2019 04:38 AM
Apr 04 2019 02:58 AM - edited Apr 04 2019 02:59 AM
SolutionSelect the cells you want to conditionally format and enter this conditional formatting formula:
=NOT(ISNUMBER(A2))
The foregoing formula assumes that your dates start in A2.