Extrapolate text from rich text formula

Hi,

I created a "change log" table, anytime certain fields change, it will log the old data and the new data, then I have a formula field set up to tell me if that field "Changed" or "No Change"

Field is Rich Text:

If([NEW BM STATUS]=[OLD BM STATUS], "<div style=\"color:white; background-color:green;\"> NO CHANGE</div>", "<div style=\"background-color:pink;\">"& "CHANGED"&"</div>")

When we download the report for someone to work from - the rich text formula shows up. I need a way to extrapolate just the "changed" or "no change" so people can have an easier time filtering changes.

this is what the report looks like downloaded to csv:

What can I do to get just the "changed" or "no changed"?

Thanks!

Renee