Acting on info in various columns if certain conditions are met

[Confused in Wales]

Hi
I am new to this forum so apologies if I've put this in the wrong place.

I have a spreadsheet which is basically a list of people in one column, 7 domains identified in the next 7 columns and then a number of courses they may have attended in the next few columns. Each person must meet 7 domains over 5 years. Each course allows an individual to meet a specific domain with the vast majority of courses covering more than one specified domain. I have these listed numerically in the cell under the course name. I need to be able to see how many domains have been met by each individual. I was trying to put a formula in the 7 domain columns that would react to a date put in against a specific course by checking whether that domain was included in that course. For example, if there were 5 courses put on and an individual attended 3 of them, one of which covered domain 2, one covered domains 4 and 5 and one covered domain 6. I want that information to be seen in the relevant column at the beginning of the spread sheet. I can identify the date, and then identify the correct domain to return a true value but I can't work out if there is a way to do this which will automatically check the entire row for each column, eg that where a date is put into H5, the domains listed for the course in H are also checked. The only way I can make it work is to do it manually.

I hope this makes sense - any help would be gratefully received.

[shukla.ankur281190]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Confused in Wales]

Thank you Shukla - attached is the spreadsheet:

[shukla.ankur281190]

Thank you Shukla - attached is the spreadsheet:

Put some expected result with criteria...

[Confused in Wales]

Hi Shukla
Apologies, the spreadsheet showed how it should look if filled out. The intention would be that, if an individual attended a course, the date would be put in against the relevant individual (as at cell L4 for Fred Bloggs). On putting in that information, cell L2 would be automatically checked and the appropriate cells in cells C4:I4 coloured green (in this case Cells C4, G4, H4 and I4). Likewise, when Joe Parker attended the course shown at M1, a date is put in at M5 which should then check M2 and turn cells E5, F5, and I5 green. Does this make sense?

Thank you so much for all your help.

[shukla.ankur281190]

I couldn't understand yet how these dates will update ???? how do you know L4 should be 23.11.2016 and L6 should be 23.11.2016 and L5 should be blank ???

Please explain with criteria..