 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
01-06-2008, 04:20 PM
|
|||
|
|||
|
Positive & negitive numbers in conditional formatting statement
I know this will be a easy one for somebody, in a report field I would like
to highlight the money amounts (clear/white) for zero, red for neg Number (money owed) and green for credited money. Zero works great, but it seems that it would tell positive from negitive numbers. -- Frank 
|
|
01-06-2008, 07:57 PM
|
|||
|
|||
|
RE: Positive & negitive numbers in conditional formatting statement
Hi Frank
Use condidtional formating HTH -- Wayne Manchester, England. "Frank" wrote: > I know this will be a easy one for somebody, in a report field I would like > to highlight the money amounts > (clear/white) for zero, red for neg Number (money owed) and green for > credited money. Zero works great, but it seems that it would tell positive > from negitive numbers. > -- > Frank
|
|
01-06-2008, 07:57 PM
|
|||
|
|||
|
RE: Positive & negitive numbers in conditional formatting statement
Hi Frank
Use condidtional formating HTH -- Wayne Manchester, England. "Frank" wrote: > I know this will be a easy one for somebody, in a report field I would like > to highlight the money amounts > (clear/white) for zero, red for neg Number (money owed) and green for > credited money. Zero works great, but it seems that it would tell positive > from negitive numbers. > -- > Frank
|
|
01-06-2008, 08:17 PM
|
|||
|
|||
|
RE: Positive & negitive numbers in conditional formatting statement
Sorry just the "title" of your post.
Are your working with a number field or a text field. If number the CF will (should) work ok -- Wayne Manchester, England. "Frank" wrote: > I know this will be a easy one for somebody, in a report field I would like > to highlight the money amounts > (clear/white) for zero, red for neg Number (money owed) and green for > credited money. Zero works great, but it seems that it would tell positive > from negitive numbers. > -- > Frank
|
|
01-06-2008, 08:17 PM
|
|||
|
|||
|
RE: Positive & negitive numbers in conditional formatting statement
Sorry just the "title" of your post.
Are your working with a number field or a text field. If number the CF will (should) work ok -- Wayne Manchester, England. "Frank" wrote: > I know this will be a easy one for somebody, in a report field I would like > to highlight the money amounts > (clear/white) for zero, red for neg Number (money owed) and green for > credited money. Zero works great, but it seems that it would tell positive > from negitive numbers. > -- > Frank
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
