conditional formating IF statement

[scabertrain]

Trying to get conditional formating on a column.
if cell in column B starts with 5 and corresponding cell in column A is greater than 90 then make the cell in column B red
i've got a normal formula down but its not usable for conditional formating.
IF(AND(A1>90,--LEFT(B1)=5),"RR","")

[martindwilson]

conditional format
formula is
=and(a1>90,--left(b1)=5)

[scabertrain]

Thx! did the trick

[scabertrain]

=and(a1>90,--left(b1)=5)

regarding this formula for conditional formating. if i wanted to add an OR statement how would i go about it?

if a1>90 & b1=5 then purple
OR
if a1>120 & b1=4 then purple.

[NBVC]

=or(and(a1>90,--left(b1)=5),and(a1>120,--left(b1)=4))