Please correct Conditional Format formula -

[srizki]

=AND(F13="",LEFT(H13,4)="0")
=AND(F13="",LEFT(H13,4)=0)

Both formulae are not working.

I want the formula to highlight the cell if the two conditions are true.
The corresponding cell in colulmn F is blank and,
the 5th digit the from the left or 4th digit from right, (always eight digits account number), is "0".

Thanks

 

[philwojo]

Try this:

[COLOR=#333333]=AND(F13="",mid(H13,4,1)=0)[/COLOR]

 

[Fluff]

Why are you comparing 4 digits to zero, or do you want to extract the 4th digit?

 

[srizki]

Sorry I got it,
I should be using mid function instead of left or right.
thanks Fluff.

Thanks all.

 

[srizki]

Thank you philwojo