Forum Discussion
Conditional Formatting based on the date of another column
Hello! Not sure if this is possible.. I have a rule that changes the due date (column M) text to bold red text if it is passed today's date (see rule below, Cell Value <=TODAY()), this rule works...
A better option is to set a single CF rule that formats values in Column M to Red+Bold only
IF value in Column M < TODAY() and corresponding value in Column N is not a Number. This translates as:
=AND( M2 < TODAY(), NOT( ISNUMBER($N2) ) )