In Excel 2003 I can select a range of cells and apply a formatting to an
entire row based on the value in a cell (e.g. F4) using a formula such as

=$F4<7

so that the formatting of row 4 will depend on F4, that of row 5 on F5 and
so on.

Please can someone tell me how I replicate this in Excel 2007? I have played
around with the conditional formatting in 2007 but have not found way of
doing this.

Thanks

Carl