2007 Conditional Formatting entire row
I don't think it's a lot different than before. I selected all of, say,
rows 4:10. Then clicked Conditional Formatting and New Rule. The last item
in the Select a Rule Type list is for formulas. I entered your formula and
some formatting and it seemed to work as before.
--
Jim
"CarlSprake" wrote in message
...
| 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
|
|
|