Hopefully someone can point me in the right direction here. I have a
spreadsheet with RTD functions that are continuously retrieving real
time data.

What I need to do is look at the values in the RTD columns and display
certain special characters in other columns. Specifically, in any
given cell, I would need to display a string of text consisting of 3
different fonts and 3 different colors.

Conditional formatting only seems to work at the cell level and not
the character level so I can't use it. That leaves me with using the
Worksheet_Change event. I've written the VBA code to create the
special character string but the problem is that when the RTD values
change, the Worksheet_Change event never fires.

Does anyone know how to detect when the value returned by an RTD
function changes? Alternatively, does anyone know how I can use
conditional formatting to accomplish this?

Thanks for your help.