Forum Discussion

R-o-x-o's avatar
R-o-x-o
Copper Contributor
Apr 04, 2019
Solved

Challenging Conditional Formatting Question

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...
Conditional Formatting
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    Apr 04, 2019

    Select 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.

Twifoo's avatar
Twifoo
Silver Contributor
Apr 04, 2019

Select 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.

R-o-x-o's avatar
R-o-x-o
Copper Contributor
Apr 04, 2019

Perfect just tried this and its worked :) Maybe wasn't that challenging after all!

 

Thanks for your help!!

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 04, 2019
    You’re right. It’s not really challenging, only if you know the function that is appropriate for your situation. Anyway, I’m glad to have helped you.