Question Locked

Nested if & And statement

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Anybody out there, please I need a formula for an excel file am working on. I have date submitted, requested date, estimated completion date, and duration columns,

these are what i need to generate and to be calculated in weeks
In the estimatd completd date to be increased by 13.5 weeks.
Also if the date requested is greater than 7 days and work to be completed is 90% done it shoud highlighted in green, if it is 60% complete and it is less than 3 weeks it should be highlighted in yellow finally if it is 50% complete and less than 4 weeks it should be highlighted in red.
Thanks for your help

2 replies

by oldbaritone

Look at "Conditional Formatting"
You can build a list of conditions, and Excel will scan down until it finds the first match.

In Excel 2007, Styles - Conditional Formatting - Highlight Cells Rules - More Rules - "Use a formula to determine which cells to format"

This discussion is closed to new replies.