If you can't use Conditional Format for your problem, then you will have to
use VBA. But you cannot get a cell function/formula to run a macro. There
are a number of ways to run a macro, even automatically, but you don't
provide enough information. Post back and tell us what you are trying to do
with more detail this time. HTH Otto
"Redragon" wrote in message
...
Thanks for replying, but I've already tried the condition al formatting
and
for my project 3 conditions is not enough, any ideas?

Thanks

"macropod" wrote:

Hi Redragon,

This sounds like a case for conditional formatting (i.e.
Format|Cells|Conditional Formatting), which allows you to specify up to
three formats in addition to the cell's underlying format, depending on
whether the conditions you specify are met. No vba required.

Cheers


"Redragon" wrote in message
...
Can I run a macro from a cell function in Excel 2003 with the idea of
comparing 1 value against another and if its true, it gets highlighted
yellow?

Thanks