hi norman
A is result of a formula which subtract to number, therefore it is number
and B is the number i enter manually.conditional format work with = $A110
but when i subsititude 10 with a cell that contain a number i doesn't work.i
want to know if the format of the number (text,general or number) is
important or not.althogh i check with all format.pls help me it's very
important for me
i have another quastion.I use today function to insert the current date in a
cell, but it update itself every day I open my worksheet .I want to know is
there a function that insert a today date in a cell and don't change and
don't change tomorrow when i open my worksheet.
best regards
plainclothman

"Norman Jones" wrote:

Hi Plainlothman,

I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

The conditional format condition:

= $A1$B1

Should work with either formula or numeric values.

Please give an example of the column A and B values which give you a
problem.

---
Regards,
Norman



"plainclothman" wrote in message
...
Hi norman
I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

"Norman Jones" wrote:

Hi PlainclothMan,

Try:

Formula Is: = $A1$B1

---
Regards,
Norman