Forum Discussion
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...
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.