Hi,

I'm using 2003 where I am right now, so I cannot see all your conditions and what may be wrong with them. I noticed, though, that you include an IF statement in your condition where it is not necessary. Instead of

Formula Is: =IF($H24="Not Started",1,0)

you can use

Formula Is: =$H24="Not Started"

or instead of

Formula Is: =IF(OR($H24="Completed",$H24="Postponed",$H24="Discarded"),1,0)

you can use

Formula Is: =OR($H24="Completed",$H24="Postponed",$H24="Discarded")

There is no need to wrap the condition into an IF statement that returns 1 or 0. The condition itself will return TRUE or FALSE, so that will trigger the formatting.

Also, I noticed that not all cells have the same conditional formatting, but I could not see the conditional formatting on all cells, due to the incompatibility with 2007. If the conditional formatting is different between cells, they will of course format differently, too.

Finally, there are cells that are shaded with a background in their native, non-conditional format. This will be overwritten by the conditional formats, but if no condition applies, the shading will appear. This may be a source of confusion, too.

Maybe you could post this in the 2007 forum, so that it gets picked up by people who can see all your formulas.

cheers