Formula to highlight a column in RED when date is past the task end date and progress is <100%

BobbyS

Here is what I have:

Any time the task end date is past today's date and the progress is less than 100% complete, I want this to be highlighted in red. Below is the formula I am using but it does not seem to work. Please help.

=AND(date>=task_start, date<=task_end,task_progress<0.1)

Date = the weekly dates in the row in BLUE (1/4, 1/11 etc)

Task_start = Start column

task_end - end column

task_progress = Complete column

David Tutwiler

Have you looked at conditional formatting? This seems to be a perfect fit for that rather than needing a formula.

BobbyS

Yes, using conditional formatting and I have pasted what I have in it.

David Tutwiler

I think the issue is in how you're marking for 100% complete. In your formula you're saying IF less than 0.1. I think you just want to say if < 1