Formula in CF not working as expected

**ImranBhatti** · 05-10-2017, 07:34 AM

Hello

I am trying to use this formula in CF but it is not working.What am I missing

=NOT(ISERROR(FIND(LEFT(A1,1),"ABCDabcd")))

If it returns true then the cells should be highlighted with yellow fill. I need only one column A to be formatted this way.

**ImranBhatti** · 05-10-2017, 07:36 AM

O sorry.got it with format painter. thanks

**ImranBhatti** · 05-10-2017, 07:38 AM

it is also filling the blank cells with yellow.had to mark it as unsolved again.

**Punnam** · 05-10-2017, 07:52 AM

=IF(A1="","",NOT(ISERROR(FIND(LEFT(A1,1),"ABCDabcd"))))

try this

Punnam

**ImranBhatti** · 05-10-2017, 07:58 AM

Excel Wizardry....It worked.

Re: Formula in CF not working as expected