Conditional Format - assign number

J

Jootje

Hi,

I want to assign a number to a certain conditional format. When the
condition is true it should put a 1 in the cell and when the condition is
false a zero or nothing should be assigned. Anyone? I seem to make the wrong
code all the time.

Thanks,
Johanna
 
B

Bob Phillips

Use the same test that the CF uses, and return 1 for TRUE and "" for FALSE.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Jootje

Uhmmm, yes well...

I used this formula in cell B52:

=IF(D52<=D51;"1";"0")

but then nothing happens...this formula is displayed as text in the cell...
It must be something really simple, but I just don't see it...
 
B

Bob Phillips

Change the format of the cell to General.

There is no need to put quotes around the numbers.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Jootje

Thanks...it was set on text and the sheet was also in auditing mode...it
works now...I knew it was something really simple

Johanna
 
Top