Altering text colours using a formula
Just wandering if it's possible to alter the text colour using a formula
command instead of using the Text and Fill colour buttons on the Toolbar? For example - I would like the first halve of the text in a cell to be Blue and Bold and the last half of the text to be Gray and standard. |
Altering text colours using a formula
You can use Conditional Formatting to set colours depending on some
criteria, but it will apply to a whole cell - you cannot get it to apply to only part of a cell. Hope this helps. Pete On Oct 2, 12:09 pm, barry24uk wrote: Just wandering if it's possible to alter the text colour using a formula command instead of using the Text and Fill colour buttons on the Toolbar? For example - I would like the first halve of the text in a cell to be Blue and Bold and the last half of the text to be Gray and standard. |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com