Input/Output Data

I am new to this thread and forum and I am in need of some ideas and tips. My ultimate goal at work is to ensure compliance with inventory. I have been trying to play catch up with and now I am thinking I can just let excel do the work for me. My problem is needing to know how when someone completes there inventory - they can mark it on the spread sheet (Inventory has a due date) - there for if they do it AFTER the due date it would formulate a redbox. If they complete their inventory on time - it would give me a green box. I hope I am making sense with what I am trying to accomplish. Any ideas would be extremely helpful.

Originally Posted by Richard Buttrey

Hi,

You will have two dates. The Inventory due date, and the completion date. Suppose these are in cells A1 & B1.

Use a conditional format on the due date in A1 and using the formula is method add

Please Login or Register  to view this content.

and set the fill format to be red. Add a second conditional format to A1

Please Login or Register  to view this content.

and set the fill format to be green.

Regards

I will try this - Thank you. I'll reply if I have further questions. More ideas would be welcome!

Hello,

Richard's suggestion is the most straightforward and simplest approach. If your workbook structure is more complex, then please post a dummy workbook so members can see what you want better.

Good luck.

abousetta