Conditional Formatting 2010

[stugi]

I got really excited with the new options in excel 2010 (coming from 2003) but now I'm just seriously frustrated as I can't seem to get even simple formatting to work.

I have a table of data B5 : M45 (headings in A4:M4). column D has a category type text value of "BCON", "BEXP", "COMP".

I want to format the entire row of data based on the text value in column D. No matter what I do I either get nothing or just the cell in Col D formatted.

This sort of thing was easy in 2003 but I've clearly had a brain melt in 2010, can anyone show me the error of my ways?

 

[VoG]

Try the Use a formula... option and a CF formula like

=$D1="BCON"

 

[stugi]

now I'm going to claim I tried that but clearly I didn't do somethign rigth because that worked.

thanks