I don't think this is too difficult, but it would help if you show the
sample data and which cells they are in to avoid guessing.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mast" wrote in message
...
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"