What sort of "box" are you entering the "Y" into.

Or do you mean a "cell"?

How would Excel know which cells are relevant and related to a particular
product?

It probably can be done but I can offer nothing more than a generic example.

In A1 is a product name/type.

In B1 you enter "y"

Select A1 and FormatCFFormula is: =$B1="Y" Format to a color and OK your
way out.


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 14:15:01 -0700, Dudelario
wrote:

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.