Color formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

in Excel 2003 I have a cell that contains the following formula:

="Worker "&Name&" "&Surname&" was absent on"&ADate

Name,Surname and ADate are cell names as you can see.

My boss would like that the Name and the Surname would be colored BLUE and
the ADate colored RED and BOLD. Normal text should also be smaller.


Is there any way to do this? Maybe a workaround?


Thanks,
--
Luke


Luka J.
Slovenia - PortalSI
 
Copy the cell containing the formula and PasteSpecial as value into another
cell. You can then apply formats to portions of the new cell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Copy row info but not in normal column sequence 6
VLOOKUP please help 2
Index Match to add employee number 2
Split Alpha Field 2
Split surname from end of name data 4
SUMPRODUCT & INDIRECT? 4
Extract given and surname a string 3

Back
Top