Forum Discussion
sophigm
Mar 29, 2025Copper Contributor
Conditional Formatting Comparing Dates
I am attempting to create a formula that formats a cell based on whether the date (contained in the cell) is before the secondary date (on another sheet). This second date will need to be changed via...
HansVogelaar
Mar 31, 2025MVP
Select B2:E24. B2 should be the active cell in the selection
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(B2<>"", B2<'Read Me'!$C$5)
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.