| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change Colour OF Text???
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? Any help would be much appreciated :-) You can email me @: |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
| how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
| Colour of the Text in a drop box list I have ... | Excel Discussion (Misc queries) | |||
| Macro button colour change??? | Excel Worksheet Functions | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Linear Mode
