Cell color based on content

Hi guys,

I know this has been much discussed topic.

I tried with different scripts for applying cell style, however clear overrides does not work for me.

One of the scripts is here:

var myDoc = app.activeDocument

app.findTextPreferences = app.changeTextPreferences = null

app.findTextPreferences.findWhat = "sometext"

app.findTextPreferences.appliedParagraphStyle = "style1";

var myFound = myDoc.findText()

for(i=0; i<myFound.length; i++)

{

    if(myFound.parent.constructor.name == "Cell")

    {

    myFound.parent.appliedCellStyle = "grey"

     var overrides = myFound.clearOverrides();          //this is the new line added in this content

Thanks in advance for any help,

Tina