Designing a spreadsheet to track workflow
Hi,
I want to design a spreadsheet which tracks when certain pieces of work are
due and whether theyve arrived or not.
At the moment there are three cells, all in a row that I want to interact
with each other.
In the first cell the user will enter the date on which the work is due. In
the second cell, I want the user to enter €˜in, when the work is in. If no
text is entered is entered into the second cell, I want the third cell to
display the word €˜LATE, in red caps.
Ive seen something like this done, but I dont know how to do it myself.
Can anyone give me an advice or point me to a good tutorial?
Thanks
Karl
|