At 14:34 07/11/2009 -0500, Gene Young wrote:
You do not need a formula.
Er, he probably does!
Just enter (for Row 1) A1-40 in Cell B1.
=A1-40 *is* a formula.
For Row 2 you must enter A2-40 in Cell B2, etc. Copying will not work.
Oh, it will! Spreadsheets would be pretty tedious and of limited use if that were so. Filling or copying whilst allowing the formula to be appropriately modified automatically is one of the basic facilities of a spreadsheet.
You must set the conditional formatting individually for each cell you want it to apply to.
No, that's not true either. You can either just fill or copy the conditional formatting along with the cell formulae, or else use the Format Paintbrush to carry over the conditional formatting by itself.
I just verified the above and it works perfectly
Indeed it will - and even if you do it slightly more easily. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
