I have a column called DEADLINE (Column B). I'm trying to use conditional formatting to color cells based on the deadline.
I want the cell to turn red if the dealdine is equal to today's date or it has already passed, turn yellow if the deadline is within 10 days of today's date, or green if today's date is more than 10 days away.
Here's what I tried but it's not working:
=B3>=(TODAY()+11) formatted to turn Green
=B3<=(TODAY()+10) formatted to turn Yellow
=B3<=(TODAY()) formatted to turn Red
Any help would be appreciated.