Font color for negative numbers
I need help in changing the font color for negative numbers to red in a
spread sheet I have tried searching and then find using -$ find and it doesnt seem to work |
Font color for negative numbers
Try #,###.00_);[Red](#,###.00);0.00
The colors are [BLACK], [BLUE], [CYAN], [GREEN], [MAGENTA], [RED], [WHITE], [YELLOW], [COLOR n] with n from 1 to 56 Also look here (found with Google search: Excel custom format http://www.bettersolutions.com/excel...M215412021.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Regards" wrote in message ... I need help in changing the font color for negative numbers to red in a spread sheet I have tried searching and then find using -$ find and it doesnt seem to work |
All times are GMT +1. The time now is 04:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com