I have cells in column A thru F that I want to color based on a data value in cell F.

If I enter N in cell F, i want cells A thru F to color RED, if I enter Y I want the cells A thru F to color YELLOW.

Appreciate someone's help on this

Thanks