conditional formatting

[papaya]

I'm using the formula:
=HVIS($H9="Not Started";1;0)
to add green color to an entire row.
This same formula works for red color for 'not started' but will only fill one
cell with green instead of entire row, what am I doing wrong?

[teylyn]

I'm willing to help but I'm on a data plan and won't open spreadsheets that size. Please post a smaller sample. Also, your profile says you're using 2003 but the attachment is 2007. Can you adjust that?

My first blind guess is that the conditional formatting is only applied to the cell that turns red. Check the other cells for the conditional formatting. If it's there, check the condition. Does it refer to the correct cell?

[papaya]

Thanks for reminding me - changed to 2007.
uploaded smaller sample

[papaya]

Doesn't anyone have a tip on this one? I can't figure out what I'm doing wrong but I'm sure it's elementary..

[teylyn]

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