PDA

View Full Version : 2 colors in one cells.



VISHAL120
09-11-2010, 01:17 AM
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.

Bob Phillips
09-11-2010, 02:24 AM
You can set different font formats for the text in the cell, but you will need to know the character positions.

VISHAL120
09-12-2010, 10:33 PM
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 .

Aussiebear
09-13-2010, 12:35 AM
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?