View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Halsey Mike Halsey is offline
external usenet poster
 
Posts: 4
Default 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