Formatting, Conditional or otherwise

[degulito]

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

 

[JE McGimpsey]

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>

 

[Gord Dibben]

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 Format>CF>Formula 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