Forum Discussion
Solved
Conditional Formatting - red/green based on deadline date
Hello! I am making a spreadsheet to track due dates for selection items for home building. I want to be able to get a quick visual to see how progress is being made. I have it set up so that H4...
Select I4:I10.
I4 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(I4<>"",I4<=$H$4)
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.Repeat these steps, but with the formula
=I4>$H$4
and red as fill color.
Select I4:I10.
I4 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(I4<>"",I4<=$H$4)
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.
Repeat these steps, but with the formula
=I4>$H$4
and red as fill color.
- Thank you SO very much, Hans! That was something I had not yet tried, and it worked perfectly. Appreciate it, thanks again, and hope you have a great day,
