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.