You can use conditional formatting. There are instructions in Excel's
Help, and he http://www.contextures.com/xlCondFormat01.html James UK23 wrote: If I want to change a specific type of text in a spread sheet what do I have to do? For example; If I want to have a figure of £5.00 in green, but a figure of - £10 in red. How would I be able to tell Excel how to do this? Would it be a IF formulae? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com