Change conditional format (color) of a cell based on another celll (Excel 2010)

Hi ffnptown

The number in B, is it number in this form: 12-0011212 21
If so what part are you referring to being >20

If it is the left part you can conditional format using:

Formula:

=LEFT($B1,FIND("-",$B1)-1)+0>20

If it is the right part you can conditional format using:

Formula:

=RIGHT($B1,LEN($B1)-FIND(" ",$B1))+0>20

Or is is it the middle part!

For column C:

Formula:

=$C1="X"