Condition Formatting

[sachar]

Dear All,

With reference to the attach sample file, May I know what is the wrong with Condition Formatting formula the worksheet Column ”F” that should be highlighted, which are start with the Omani word in the column “F”.

Please help me?
Thanking you.

 

[Velen]

Can't see why the conditional formatting does not work directly on column F.

Used a workaround by adding a new column J which does the following:

=IF(ISNUMBER(SEARCH("omani",F5)),1, 0)

That is check if Column F contains Omani (the formula is case sensitive)

Then using the Column J for the Conditional formatting:

=IF(J5=1,TRUE,FALSE)

Maybe someone else can figure out why:

IF(ISNUMBER(SEARCH("omani",F5)),True, False) is not working directly in the Conditional Formatting

The reworked file attached.

Cheers

 

[Luke M]

Since the cell in F5 only contains the word omani, you'll want to change the formula to use search. Also, I noticed the applied range started in row 4, but your formula is looking at row 5. I'm guessing that it was an accident to offset the formatting (your rule says to highlight row if cell above meets criteria.

New formula:
=SEARCH("omani",F4)

 

[sachar]

Dear All,

I want to say Thanks to all for solved my problems.