conditional formatting not cooperating

[pleasehelp]

Hi!
First time using the coditional formatting option....pretty simple really.

If a cell value is less than or equal to 39, shade it red.
If a cell value is greater than or equal to 79, shade it pink.

don't know why the cell is always red, regardless of its value. No other conditional formatting is set on the worksheet. I've also deleted the 2nd condition and the cell is always red again.

What am I doing wrong? Please advise.
thanks in advance.

[Pepe Le Mokko]

What version of XL are you using ? Please provide a sample sheet

[Special-K]

Assuming your cell is A1
your formulas should be

=(A1<=39)
format as red
=(A1>=79)
format as pink

Make sure you clear the sheet of all current Conditional Formulas before entering the above formulas.

If this doesn't work then post a sheet as stated

[pleasehelp]

What version of XL are you using ? Please provide a sample sheet

Hi Pepe, I'm using Excel 2002(10.2614.2625) on Window Vista.

[Fotis1991]

Hi

Shows red, if it's empty!(a1<=39)

You need, this.

For red coNdition, formula is: =AND(A1>0;A1<=39)

fOR PINK: =A1>=79

Hope to helps you.

[pleasehelp]

Hi Special-K,

I did a Goto special formatting from the edit pull down window and none were found. I didn't type anything in...just use the conditional formatting from the format pull down window. There is an existing formula which calculates the value from other settings...where do I type in the formula above?

[Fotis1991]

Excuse me. Did you see my answer??

Note: In your example, your Conditional formatting in K3, IS cell VALUE=<=3.

In your question, is 39.

[pleasehelp]

Hi Fotis,

where do I type the formula above? I already have a formula for some calculation. Please see attachment from the thread above. thanks.

[Fotis1991]

In K3.

See the example

[pleasehelp]

I can't believe it, but I forgot about the decimal point....I was reading .39 as 39 hence the condition is always true.
Thanks for all your help!!!

[pleasehelp]

Thanks Fotis,
I've learned something new today.