Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

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 -

Version?

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