ExcelBanter - Color formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Color formatting (https://www.excelbanter.com/excel-worksheet-functions/166886-color-formatting.html)

Color formatting

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

Color formatting

Copy the cell containing the formula and PasteSpecial as value into another
cell. You can then apply formats to portions of the new cell
--
Gary''s Student - gsnu200758

"Spancek" wrote:

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