K
Karl
Hi,
I want to design a spreadsheet which tracks when certain pieces of work are
due and whether they’ve 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.
I’ve seen something like this done, but I don’t know how to do it myself.
Can anyone give me an advice or point me to a good tutorial?
Thanks
Karl
I want to design a spreadsheet which tracks when certain pieces of work are
due and whether they’ve 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.
I’ve seen something like this done, but I don’t know how to do it myself.
Can anyone give me an advice or point me to a good tutorial?
Thanks
Karl