Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format for Blank Cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Based on Age, but not if blank. | Excel Worksheet Functions | |||
Conditional format - blank vs. 0 | Excel Discussion (Misc queries) | |||
Conditional Format A Cell If Row Is Blank | Excel Discussion (Misc queries) | |||
Conditional formatting: format when range of cells are blank | Excel Discussion (Misc queries) | |||
Conditional format -blank | Excel Worksheet Functions |