(Sorry, it's hard to explain whats in my head! FYI: My project has nothing to
do with making cakes….it’s more for auditing files for certain documents. The
cakes seemed easier to explain.)

Well the list of ingredients would be in Column A, more specifically
starting in A2, then if I select 'pound cake' in Cell B1 (from a pull-down
list), I would like for the cells in Column B next to the ingredients in
column A that DO NOT pertain to making a 'pound cake' to fill-in/shade black
or perhaps display 'n/a'. I know that I would need to make conditions in each
cell in Column B (next to the ingredients in Column A). The question is
exactly what formula/condition are they?

Could you please elaborate on the 'Database' idea? That sounds easier,
especially for updates. Where can I look to create that within excel?


Thanks for your help!

--
-Liz


"T. Valko" wrote:

Is this possible??

Yes

Is this clear?

Not exactly! How do you know what ingredients are or are not needed for
pound cake? Obviously, we (as humans) could look at a list of ingredients
and tell that chili powder is not an ingredient for making pound cake but
how do we let Excel know that?

So, you'd have to create a specific list of the ingredients for making pound
cake then compare that specific list to a more general list and then apply
the formatting to the ingredients on the general list that don't belong with
pound cake.

Or, you can make an ingredient "database" where you would type in pound cake
then all the ingredients for making pound cake would be listed.

--
Biff
Microsoft Excel MVP


"LSG" wrote in message
...
I am trying to figure out, if possible, to make certain blank cells in a
row/column to be filled-in (blacked out) if a certain cell contains a
particular text. For example:

Let's say I'm wanting to create a spreadsheet that will help me indicated,
from a list of ingredients in Column A, what ingredients to make for
certain
cakes.

If Cell B1 Contains the word 'pound cake', then I wanted a range of cells
in that same column to shade out those ingredients that do not pertain to
making a pound cake.

Is this clear? Is this possible?? Thanks!
--
-Liz


.