Hi

you can't use a formula to do this as formulas can't change formatting.
However, you can use conditional formatting
to do, select the relevant cells in your 150000 rows (i'm guessing it's a
column or so of IF formulas) and choose
format / conditional formatting
cell value is
equal to
"Evaluate"
click on the format button - set the formatting, click OK
choose ADD
choose
cell value is
equal to
"Leave"
click on the format button - set the desired formatting
click OK twice


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"blopreste3180" wrote in message
...
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.