Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display text when a cell value is 0 for accounting?
I am using Office Exel 2007 and I am having trouble getting the data to
display the way I want it to by using the IF function to test the cell. My situation is as follows I have cell C25 Formatted for accounting and the value is $0.00. Currnetly, the value in the cell is shown as " $ - ". Instead of showing this I want to do something like the example as follows: If the dollar amount in C25 is equal to 0, then display "PAID" in bold letters with geen fill, If the dollar amount in C25 is equal to or greather than $5.00, then I want the dollar amount to be displayed. How can I make this happen? Please reply ASAP. Thank you, -- John R. L. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display text when a cell value is 0 for accounting?
You have two options. Custom formatting, and conditional formatting.
To custom format a cell, right-click on it, choose Format Cells...NumberCustom You specify the format for up to four values, each separated by a semi-colon. The standard values a positive;negative;zero;text The easiest to probably to change one of the custom formats already on file. If custom formatting isn't powerful enough for you, then use conditional formatting. Regards, Fred. "John" wrote in message ... I am using Office Exel 2007 and I am having trouble getting the data to display the way I want it to by using the IF function to test the cell. My situation is as follows I have cell C25 Formatted for accounting and the value is $0.00. Currnetly, the value in the cell is shown as " $ - ". Instead of showing this I want to do something like the example as follows: If the dollar amount in C25 is equal to 0, then display "PAID" in bold letters with geen fill, If the dollar amount in C25 is equal to or greather than $5.00, then I want the dollar amount to be displayed. How can I make this happen? Please reply ASAP. Thank you, -- John R. L. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display text when a cell value is 0 for accounting?
conditional formating will work for the colors and the bold , then a simple
if function will work to produce the word, conditional formating is the only way to bold and color the format of the text in styles click conditional formiting (highlight the range first), then select new rule, and then "format text that contains" then in the drop down select spefic text and the type the text you would like to auto format click format and then do what ever you please "John" wrote: I am using Office Exel 2007 and I am having trouble getting the data to display the way I want it to by using the IF function to test the cell. My situation is as follows I have cell C25 Formatted for accounting and the value is $0.00. Currnetly, the value in the cell is shown as " $ - ". Instead of showing this I want to do something like the example as follows: If the dollar amount in C25 is equal to 0, then display "PAID" in bold letters with geen fill, If the dollar amount in C25 is equal to or greather than $5.00, then I want the dollar amount to be displayed. How can I make this happen? Please reply ASAP. Thank you, -- John R. L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display text when a cell value is 0 for accounting? | Excel Worksheet Functions | |||
How do I display text when a cell value is 0 for accounting? | Excel Worksheet Functions | |||
How do I display text when a cell value is 0 for accounting? | Excel Worksheet Functions | |||
Accounting format now no longer display negative figures in ( )'s | Excel Discussion (Misc queries) | |||
Display 0's in Accounting format | Excel Discussion (Misc queries) |