Yeh I can try and help. How many columns do you have?
My approach would have been to use a for each row, loop through each row and get cell colour of column A, then Column B. Use an if statement to say if Column B is “Color [Yellow]” then Write cell as blank…