Hello,

I am looking for a code to add to my existing code that can enable me do a
comparison of data in the cells of column B and match against a value which
will initiate a search for available data in a name list and place this data
into the respective cell on that row then finally paint the cell (in the name
list) as red(used)/orange(reserved)/Green(Not used) to indicate non
availability.

The colors will be the test case for data availability.

My existing code is based on a change event and works ok, i only need to
insert the code where there is a selection of data from a list (validation
list) and input the right data into relevant cell5

For Each cell In Target.Offset(0, 0)
cell.Offset(0, 14).Formula = "=""ULUS"" & O:O"
'this is where i want to place the script
cell.Offset(0, 5).Formula = "test condition"

F.Y.I
My named list has 7 colums of info with relevant header, data1, data 2
.....data7 so the search on the list i would think would be referencing
relevant header then looking for data availability (white cell) and doing its
magic to use up and color the cell.

And there are multiple name list for each test case. because the change
event has currently 4 cases within the select case. so i can adapt the code
to each test case.



Thanks for the anticipated help.

Regards,
Derrick