possible?

[bam12]

i have column of cells from I7 to I33, each cell has a formula in.

What I would like to do is when one of those cells is a negative number i want that cell and all the rest below it to change to another color. Is this possible, bynot using a macro?

 

[barry houdini]

Select your range I7:I33 with I7 active cell

Format > Conditional formatting

"formula is"

=MATCH(TRUE,I$7:I7<0,0)

format as desired

 

[bam12]

thank you

Thank you Barry
worked like a charm