In the Heading cell:

=if(max(c9,d37)0,"Heading2here","heading1here")

confuscious wrote:

i want to make a cell [heading 1] (that is a list of two headings) change to
[heading 2] if either one of two other cells are greater than 0 but revert
back to [heading 1] if not.

--

Dave Peterson