Conditional Formatting Based On Dates

[AMC2]

I'm in O365, and I know this shouldn't be this difficult, but for some reason I'm struggling. I need to format a column based on due dates and % complete.

Column A is % complete, Column B is Due date.

Anything that is 100% complete in Column A, regardless of date, would be green. (Complete)
Anything not 100% complete, and the due date in Column B is within 2 weeks of today's date, would be yellow. (At Risk)
Anything past due would be Red. (OVER DUE)

I've got the first and last highlighting to work using =A1=100%, and then =A1<TODAY(), but I cannot for the life of me figure out how to format the 'at risk' section.

There's got to be a simple solution that I'm just too cross eyed to see at the moment.

 

[kevin9999]

Like this maybe?

Book1
	A	B
1	% Complete	Due Date
2	100%	4/09/2023
3	90%	16/09/2023
4	80%	3/09/2023
5	75%	29/09/2023
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B5	Expression	=AND($A2<1,$B2<TODAY())	text	YES
A2:B5	Expression	=AND($A2<1,$B2<=(TODAY()+14))	text	YES
A2:B5	Expression	=$A2=1	text	YES

 

[AMC2]

Worked like a charm, and now I feel stupid for not being able to get such a simple solution! Many thanks!

 

[kevin9999]

Worked like a charm, and now I feel stupid for not being able to get such a simple solution! Many thanks!

Don't beat yourself up, we all get mental blocks at times when we've been looking at a problem too hard. Anyhow, happy to help and thanks for the feedback