True if starts with zc

[clausboss]

Hi

I need to make som conditional formatting. I need somthings to be big if the a collum starts with ZC but if it starts with 33 then i need to be red have can i do this.

I know that i can use conditional formatting but he i can´t say if starts with, so the solotion for me is to make a if formal but have do i make a if formel =if(a1starts with zc;1;2) what is the command for som things starts wit??

Claus

 

[Andrew Poulsom]

It's:

=IF(UPPER(LEFT(A1,2))="ZC";1;2)

 

[clausboss]

That is the thing I love and hate aboute excel, when som one know the answer it is so easy...

Many thanks I works!