excel conditional formating help needed..

[slinxy]

Hi

I working on a sheet at the moment and I want to change the conditional formating of a cell if the text entered contains the letter "h", as the three valid enteries will be "H", "H/2" and "BH" and all three enteries will have the same format. The issue is that I'm already using two of the conditions for "S" and "U" and only seem to have a space for one other, and theres nothing that says "contains" in the rules.. nor can I spec a range to enter the vaules for conditional formating to look at.

Thanks

 

[MarcLister]

In Excel 2007 I can add new rules using the aptly named Add New Rule button. What version of Excel have you got?

 

[dazzerd]

Hmm if you need S U and H to all be one colour then you can prolly just put some or statements in their?

Change conditional formatting, to formula is rather than cell is and type

=IF(OR(A1="h",A1="u",A1="s"),1,0)

Then paste special formate over your entire range of cells, this will colour all cells which equal h,u or s (or whatever you choose) to be the colour you want.

a1 is your cell ref obviously.

Hope this helps