B
Ben
Is there a way I can make the IF formula run a macro IF a
cell contains a matching value?
cell contains a matching value?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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).
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).
B
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?
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?
P
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
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
B
Ben
ah.. sounds good. I'll give it a try...
Thanks Peo, and Bob.
Thanks Peo, and Bob.
B
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!
make a formula report a value to a cell and if that value
is within a criteria conditional formatting changes as
neccessary.
Thanks!