Conditional Formatting

[Dudelario]

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.

 

[Max]

Not very sure, but think this tinker should give you some ideas ..

Suppose A1:A10 houses 10 product names,
and the user will enter "Y" within B1:B10

1. Format A1:A10 in grey fill (via Format>Cells ..)
2. Select A1:A10 (A1 active)
then apply conditional format
using Formula Is: =$B1="Y"
Format > Patterns tab > "No Color" > OK out

Test it out. When you enter a "Y" (it's not case sensitive, of course)
within B1:B10, the corresponding fill in A1:A10 will be "cleared"

 

[Gord Dibben]

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 Format>CF>Formula is: =$B1="Y" Format to a color and OK your
way out.


Gord Dibben MS Excel MVP