I have a workbook for tracking the whereabouts of equipment. Equipment is
allocated, by an "X" in columns and a cell, at the top of the column (using
data validation) records if the equipment is "Allocated" or "In Use" or
"Returned" and changes the colour of the column accordingly. There are
several columns of "Allocated" and "In Use" equipment at any one time.
How can I, in a separate column, mark each individual item of equipment as
"Available" or Not Available" depending on the three conditions of
"Allocated" & "In Use" and the "X"