Hello,

Is there a way to affect the formatting of other cells by changing the
text in a "defined cell"?

i.e. If cell A10 reads "blah-blah-blah" then the formatting in cells
U36:N46 will remain unchanged;
however, if the text in cell A10 changes from "blah-blah-blah" to
anything else then the formatting
in cells U36:N46 will change.

I tried this using conditional formatting, but could not get it to
work because the text change needs
to occur within the cell with the format change.

Please help.

SIV

One way:

Select U36:N46. Choose Format/Conditional Formatting...

Set the dropdown and inputbox to

CF1: Formula is =$A$10<"blah-blah-blah"
Format1: <format


In article .com,
wrote:

Hello,

Is there a way to affect the formatting of other cells by changing the
text in a "defined cell"?

i.e. If cell A10 reads "blah-blah-blah" then the formatting in cells
U36:N46 will remain unchanged;
however, if the text in cell A10 changes from "blah-blah-blah" to
anything else then the formatting
in cells U36:N46 will change.

I tried this using conditional formatting, but could not get it to
work because the text change needs
to occur within the cell with the format change.

Please help.

SIV

I tried this using conditional formatting, but could not get it to
work because the text change needs
to occur within the cell with the format change.

You misunderstand the rules.

Select U36:N46 and FormatCFFormula is:

=$A$10<"blah-blah-blah"

Format to a color and OK

If A10 reads blah-blah-blah then no color.

Change A10 to bloo-bloo-bloo and color will change in U36:N46


Gord Dibben MS Excel MVP

On 24 May 2007 15:23:13 -0700, wrote:

Hello,

Is there a way to affect the formatting of other cells by changing the
text in a "defined cell"?

i.e. If cell A10 reads "blah-blah-blah" then the formatting in cells
U36:N46 will remain unchanged;
however, if the text in cell A10 changes from "blah-blah-blah" to
anything else then the formatting
in cells U36:N46 will change.

I tried this using conditional formatting, but could not get it to
work because the text change needs
to occur within the cell with the format change.

Please help.

SIV