Cell format overrules conditional formatting

[ticl]

I have formatted cells using conditional formatting based on a given value in my workbook being equal to either "EUR" or "USD". The custom format it should get when "EUR" is: "€"#.##0,00 (see screenshot 1).

It shows the correct format (see below image), however when you would paste this cell value in a Word document, then it does not paste the currency symbol.

When I check the format of the cell directly

, then the format shows differently than what I have set in the conditional formatting: _(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_)

Can someone please explain me why the cell format in the last step is not the same as to the format I have set it in the conditional formatting? Is it possible to make sure it properly takes the correct format being "€"#.##0,00 ?

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
Conditional formatting does not change the actual cell format, just the manner in which it's displayed.

 

[ticl]

Hi & welcome to MrExcel.
Conditional formatting does not change the actual cell format, just the manner in which it's displayed.

Thanks for your prompt reply Fluff. Is there any way to manipulate the actual cell format on a certain condition?

 

[Fluff]

Yes, it's called conditional formatting.
How are you copy/pasting the data into word?

 

[ticl]

Yes, it's called conditional formatting.
How are you copy/pasting the data into word?

Selecting multiple cells in Excel and copy

Selecting target cells in a Word table (same number of cells as from where I copied) and paste

 

[Fluff]

In that case I think the only way to keep the format, is to physically change the cell format, rather than using conditional formatting.