ExcelBanter - How to globally replace a value and set a format.

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to globally replace a value and set a format. (https://www.excelbanter.com/excel-discussion-misc-queries/112021-how-globally-replace-value-set-format.html)

Nicholas

How to globally replace a value and set a format.

I have a bunch of records that contain data similar to:
job_history.txt:DC_D01|Update Statistics|01062005|430|01062005|431XXX|2|

I want to change all 2005 to be bold and RED.

Any ideas how to do this?

Thanks

All times are GMT +1. The time now is 07:32 AM.