Conditional formatting to control individual character inside a cell?

[omairhe]

Hello,

I have a data set that ends with Euro symbol sign. For exambple 2,353.00 €

These symbols are in both horizontal and vertical cells. Because the data looks quite complex. Is there a way to give the Euro symbol a different color (red)

The cells are formatted as Euro Currency with separator and two decimals.

From this
2,451.00 €
658.00 €
569.00 €

To this
2,451.00 €
658.00 €
569.00 €

Thank you and will appreciate any help.

 

[Special-K99]

According to another post

You can't Conditional Format part of a cell.

but you can achieve it via VBA.

Further info here
https://www.mrexcel.com/forum/excel-questions/946575-conditional-format-part-cell.html