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