Hi guys,

sorry if the title doesn't really give you a good overview of the issue...

I basically am trying to create an in/out system in excel.

When we give out access cards to people, they are logged on a spreadsheet then updated when they return them.

Capture.PNG

Based on the above image, there are 2 conditions to know the card is with us and ready to give out again:
1) The cell colour is green
2) The "Actual Return" is filled in.

So for example badge 1,5 are all in and 2,3,4,6,7 are out.

So in theory, I want a table to display the below:

Badge 1 | IN
Badge 2 | OUT
Badge 3 | OUT
Badge 4 | OUT
Badge 5 | IN
Badge 6 | OUT
Badge 7 | IN

Can someone help me with a formula to do the above please?

Thanks,
Dan