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