ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Color of tracked changes (https://www.excelbanter.com/excel-worksheet-functions/199894-color-tracked-changes.html)

Nick Cumberbatch

Color of tracked changes
 
I recently started to use Excel 2007

I have a shared worksheet which I sent to a colleague for review. After I
received it back, and looked for his changes I could barely see them as the
color was too faint a really pale yellow.

How can I change the color to a bolder color

NC


Sheeloo

Color of tracked changes
 
You can Search & Replace by Format... and you can "choose format from a cell"
Open the Replace dialog box, click on Format agains Find What, Click on
Choose...
In Format agains Replace With, click on Format and choose what you want...

Hit Replace All... Do keep a copy of your file till you are sure you are
getting what you want.

"Nick Cumberbatch" wrote:

I recently started to use Excel 2007

I have a shared worksheet which I sent to a colleague for review. After I
received it back, and looked for his changes I could barely see them as the
color was too faint a really pale yellow.

How can I change the color to a bolder color

NC


Nick Cumberbatch

Color of tracked changes
 
Sorry this didnt work

"Sheeloo" wrote in message
...
You can Search & Replace by Format... and you can "choose format from a
cell"
Open the Replace dialog box, click on Format agains Find What, Click on
Choose...
In Format agains Replace With, click on Format and choose what you want...

Hit Replace All... Do keep a copy of your file till you are sure you are
getting what you want.

"Nick Cumberbatch" wrote:

I recently started to use Excel 2007

I have a shared worksheet which I sent to a colleague for review. After
I
received it back, and looked for his changes I could barely see them as
the
color was too faint a really pale yellow.

How can I change the color to a bolder color

NC


Sheeloo

Color of tracked changes
 
Pl. send the worksheet to me ).

I tested it at my end and it works.

"Nick Cumberbatch" wrote:

Sorry this didnt work

"Sheeloo" wrote in message
...
You can Search & Replace by Format... and you can "choose format from a
cell"
Open the Replace dialog box, click on Format agains Find What, Click on
Choose...
In Format agains Replace With, click on Format and choose what you want...

Hit Replace All... Do keep a copy of your file till you are sure you are
getting what you want.

"Nick Cumberbatch" wrote:

I recently started to use Excel 2007

I have a shared worksheet which I sent to a colleague for review. After
I
received it back, and looked for his changes I could barely see them as
the
color was too faint a really pale yellow.

How can I change the color to a bolder color

NC



All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com