Format the cells
I want to have the following format on the cells.
If the cell with the absolute value is less than 0.05, display ^^ except 0, while display '--' if the cell contain 0. The other value display as General currency format (e.g. $523,000). Thanks. |
Format the cells
Hi,
Am Tue, 25 Nov 2014 14:18:00 +0000 schrieb pkedward: If the cell with the absolute value is less than 0.05, display ^^ except 0, while display '--' if the cell contain 0. The other value display as General currency format (e.g. $523,000). if you use xl2007 or later format your cell currency and create the other rules with Conditional Formatting Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com