Hi, 

My level of experience with Excel would be that of “I know what question to ask google / Chat GPT / Gemini to get an answer” and then implement that answer. Some basic VBA and formula knowledge. 

My current challenge is this….. I have 3 columns of data in columns A, B, C.

Column A is a name, Column B is a list of training they have completed and Column C is the list of training that they SHOULD have completed. I have the ‘filter’ on the headers so I can select a name that shows me their completed training.

What I would like is a way to, when I filter by a name (Column A) and it shows me the persons completed training (Column B), it highlights in RED in Column C what training is missing from Column B as matched against Column C and what training is NOT missing in green as matched against Column C. 

Not sure if creating rules or a VBA or some formulas would achieve this result. Your assistance would be greatly appreciated. 

Thankyou. 

Sebastian 

​Hi,  My level of experience with Excel would be that of “I know what question to ask google / Chat GPT / Gemini to get an answer” and then implement that answer. Some basic VBA and formula knowledge.  My current challenge is this….. I have 3 columns of data in columns A, B, C. Column A is a name, Column B is a list of training they have completed and Column C is the list of training that they SHOULD have completed. I have the ‘filter’ on the headers so I can select a name that shows me their completed training. What I would like is a way to, when I filter by a name (Column A) and it shows me the persons completed training (Column B), it highlights in RED in Column C what training is missing from Column B as matched against Column C and what training is NOT missing in green as matched against Column C.  Not sure if creating rules or a VBA or some formulas would achieve this result. Your assistance would be greatly appreciated.  Thankyou. Sebastian   Read More

​