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