How can I change the colour of cells using a macro?
 

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

How can I change the colour of cells using a macro?
 

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

How can I change the colour of cells using a macro?
 

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