Hi there, I am looking to find out how you can have a cell that has a word in this and when deleted, is deleted from another cell also within the same tab
For example - 'Jeff' works on the 27th June on X project (cell A1) - therefore cant work on project Y also on 27th June (cell A13) therefore cell A13 needs to be coloured red as he is unavailble. Equally, if 'Jeff' was take off project X (cell A1) we could delete the info in this cell and a formula would also change cell A13 to 'blank' therefore showing that he is avialble
I hope this makes sense and someone can help
Thanks
Matt
Bookmarks