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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colour cell (or text) depending upon IF Function result 4
Intuitive Macro that changes based on cell value 13
if cell colour is then change cell colour in range 2
Macro to change cell colour based on words 3
Macro to merge cells of the same colour/pattern index 1
how can i change colour of a cell 2
Updatig the Next Consecutive Empty Cell in a Range 3
How to change the colour of a cell continually? 4

Back
Top