I want to create a conditional format whereby users can enter "Y" in a box by
different product types which will change the background pattern from grey to
clear for all relevant cells relating that that product while leaving cells
for other products grey'd out. Is this possible to do using conditional
formatting or formula? I only know the basics of Cond formatting and can't
seems to put the dots together on this. Thanks.