So I'm having a bit of a problem with some conditional formatting (I posted
this question at the bottom of one I answered a couple of days ago and I
don't think anyone has seen it there).

I have a column that has cells that say "Incomplete" (with
red formating) and change to "complete" (green formating) when a value I look
up in another cell is met, say if a cell is 0 somewhere else, it's
incomplete, and if it's 1, it's complete. Once it turns to complete, I want
it to stay that way (until
next time I load the workbook) even if the cell I'm looking at turns back to
0. Any ideas? I tried a counter, nested ifs, maybe I need to do it in the
vba code?

Thanks.