Conditional Formatting
 

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.

Conditional Formatting
 

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 FormatCells ..)
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"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.

Conditional Formatting
 

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.