Conditional Format - assign number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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...
 
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)
 
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
 
Back
Top