WPS表格里将替换的字符标红

function tt()

{

let x = 'sd'

let y = 'xyz'

for (let i of Range('A1:A4').Cells) {

let arr = i.Value2.split(x)

if (arr.length > 1) {

i.Value2 = arr.join(y)

let n = 1

arr.pop()

for (let j of arr) {

n += j.length

i.Characters(n, y.length).Font.Color = 255

n += y.length

}

}

}

}