SyntaxFix

[excel] Format cell if cell contains date less than today

Your first problem was you weren't using your compare symbols correctly.

< less than
> greater than
<= less than or equal to
>= greater than or equal to

To answer your other questions; get the condition to work on every cell in the column and what about blanks?

What about blanks?

Add an extra IF condition to check if the cell is blank or not, if it isn't blank perform the check. =IF(B2="","",B2<=TODAY())

Condition on every cell in column

enter image description here

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to conditional-formatting

• Vue.js: Conditional class style binding • Conditionally formatting cells if their value equals any value of another column • Format cell if cell contains date less than today • Conditionally formatting if multiple cells are blank (no numerics throughout spreadsheet ) • Change the color of cells in one column when they don't match cells in another column • Conditional formatting based on another cell's value • Conditional Formatting (IF not empty) • Conditional Formatting using Excel VBA code • Conditional formatting, entire row based • Conditional formatting using AND() function