Need to popuplate a cell with 'Y' or 'N' based on the check with multiple columns values

I am new to this Excel Macro, but now I need to write a code for below scenario. Appreciate your help. I need to populate 'Y' or 'N' in a cell (Ex: A2) with color if 'Y' Green or 'N' Red, based o...