I have some cells that use the results of a formula, for example =”Today is: “& TODAY() and I would like to have the two parts in different text color (without making two separate cells). Is this possible?
I have several cells with similar setup and would like to do this for making the information display on the screen friendlier and easier to highlight.
—–
The Tominator
It is possible. Create a table with one cell. Put "Today is: " in that cell with the color you like. Then in any cell you want to use that text, refer to the cell instead of the text in quotes. So if the 1-cell table is "Color Text" then:
=Color Text::$A$1 & TODAY()
Make sure you use preserve row and column when referring to that cell. Thus the dollar signs before the A and 1. This will keep that reference steady as you copy and paste elsewhere.
Another option is to simply have two cells, one to the left with "Today is:" and have that right justified. Then the other cell with TODAY() next to it that is right justified. You can remove the border line between these cells.