2007 Conditional Formatting entire row

[Guest]

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

 

[Jim Rech]

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
| 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
|
|

 

[Guest]

Jim,

Thanks for your response. Yes that works OK. What I was aiming for was three
conditions (<7, <14 and <28) and setting different formats for each
condition. I couldn't see a way to apply these three separate conditional
format rules. However, I have now discovered Manage Rules and can now sort
the order in which to apply the conditions.

Thanks

Carl