Excel, checking a column and doing a calculation

[darinmc]

Hi
I have no experience at macros in Excel. I would imagine i need to use the lookup function, but no idea in creating a macro and then formatting the colours!

Col C - holds Invoice Date Created
Col D - I would like to be the number of days since Inv created.

When I run the macro, i would like it to calculate the number of days (Col C) and the current date and insert it into Col D?

Then, if > 30 make the number Green
> 60 Red
> 90 Red and say BOLD

I would appreciate any help please

Thx
Darin

 

[GlennUK]

Why don't you just use a formula to calculate number of days since Inv created ( like =TODAY()-C2 ) , and then use Conditional Formatting to colour the results.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[darinmc]

Thx
I have done that now... Didnt really think about it..
Would have liked to see a macro, bit more flexibility and maybe try a bit of different programing.

Any suggestions on finding good examples or samples?


Thx
darin

 

[SkipVought]

Why code a macro, when an Excel built-in feature is available???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlbo]

....and if you wanted a macro, you should've posted in: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question