Nested if & And statement

By sakira ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by oldbaritone In reply to Nested if & And statemen ...

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"

Related Discussions

Related Forums