Macros with formulas

[Ben]

Is there a way I can make the IF formula run a macro IF a
cell contains a matching value?

 

[Bob Phillips]

Ben,

You can make it run a function, a custom UDF, within the If clause that
returns a value, but not a macro that might manipulate the worksheet (which
is what I guess you want to do).

 

[Ben]

Bugger. Basically what I'm after doing is theres a huge
row that will be updated manually over time. in another
row there's the records original date and i'm wondering
if i could make the record highlight in blue or something
when the dates close enough together.

i.e. someone amends the date and it turns blue if it's
close enough.

i fiured a macro is the best way to amend color etc. -
don't suppose there's another way around it?

 

[Peo Sjoblom]

Have a look at conditional formatting, sounds like
it could be of use..

format>conditional formatting, select formula is and use
something like

=A1>=A2

where A1 is the original

then you could select the format, the above will change format
when the date in A1 is equal or later than the date in A2

 

[Ben]

ah.. sounds good. I'll give it a try...

Thanks Peo, and Bob.

 

[Ben]

That will work a treat. I just did a small test and I can
make a formula report a value to a cell and if that value
is within a criteria conditional formatting changes as
neccessary.

Thanks!