Hi all,
Can someone tell is there a possibility to put two colors in one cells.
for example if there is two data which is form by concatenating therefore 1 data is represented by one color and the other one by another color.
which shall display as such:
budget 1st data : 12000 represent by red color
expense 2nd data: 13000 represent by blue color
all in one cell.
many thanks for a reply for the possibility.
You can set different font formats for the text in the cell, but you will need to know the character positions.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Hi can this be done on vba. as actually i will be using this on my project and every time the calculation is over i will need to set the colors .
Yes it can be done, but as XLD has indicated you will need to know the character positions. Will there be a distinct character which can be used to differentiate between Budget and Expense?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
