 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Conditional Format - assign number
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.  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hi, > [quoted text clipped - 6 lines] > Thanks, > Johanna 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... > Use the same test that the CF uses, and return 1 for TRUE and "" for FALSE. > [quoted text clipped - 8 lines] > > Thanks, > > Johanna Change the format of the cell to General. There is no need to put quotes around the numbers. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Uhmmm, yes well... > [quoted text clipped - 20 lines] >> > Thanks, >> > Johanna 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 > Change the format of the cell to General. > [quoted text clipped - 24 lines] > >> > Thanks, > >> > Johanna
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.