Hiya,

I have a personal finance ledger going week to week. I'd like to write a
macro to change the colour of a range of cells (my bank balance) if the
number goes below a certain amount (my overdraft limit) to warn me.

How can I do this please? I have absolutely no idea how to write macros in
Excel.

Thanks in advance,

Mike

Mike

You don't need macros...check out Conditional Formatting in help or under
the Format menu (up to 2003) or on the Home tab of 2007

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Mike Halsey" wrote in message
...
Hiya,

I have a personal finance ledger going week to week. I'd like to write a
macro to change the colour of a range of cells (my bank balance) if the
number goes below a certain amount (my overdraft limit) to warn me.

How can I do this please? I have absolutely no idea how to write macros
in
Excel.

Thanks in advance,

Mike

Better to use conditional formatting then. It is found under the Formatting
menu.

Here is a link to a wealth of information:

Debra Dalgleish
http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy


"Mike Halsey" wrote:

Hiya,

I have a personal finance ledger going week to week. I'd like to write a
macro to change the colour of a range of cells (my bank balance) if the
number goes below a certain amount (my overdraft limit) to warn me.

How can I do this please? I have absolutely no idea how to write macros in
Excel.

Thanks in advance,

Mike