how do i get a TRUE value in a formula to change the color of the cells that
it references. I have an IF statement that reads as follows:
=IF(E100,IF(J10<=0,IF(M10<=0,"Evaluate","Leave")) )
This returns the value of "Evaluate" if my cell number references are zero,
and "Leave" if greater then zero. Help!!!!

I want to make this a macro that will go through all 15,000 rows of my
spreadsheet to evaluate the data.