cell object exposure outside of VBA

[Thomas Homan]

All,

Is there a way to access give cell objects from within functions without
invoking a macro of some sort?

I'm wanting to do something along the lines of:

if (a2=1000, cell(b,2).background=green, cell(b,2).background = yellow)

I know this can easily be done inside of VBA but due to our organization's
macro security level distributing a macro is a royal pain in the backside

TIA

Tom Homan

[kassie]

You use Conditional Formatting to achieve this. Iso Cell Value is, use
Formula is

"Thomas Homan" wrote:

> All,
>
> Is there a way to access give cell objects from within functions without
> invoking a macro of some sort?
>
> I'm wanting to do something along the lines of:
>
> if (a2=1000, cell(b,2).background=green, cell(b,2).background = yellow)
>
> I know this can easily be done inside of VBA but due to our organization's
> macro security level distributing a macro is a royal pain in the backside
>
> TIA
>
> Tom Homan
>
>
>

[Elkar]

This could be done with Conditional Formatting. Select cell B2, then from
the Format Menu select "Conditional Formatting"

Change "Cell Value Is" to "Formula Is"
Enter the formula: =A2=1000
Set your format (green background)
Click OK

You could add a second condition for the yellow background (=A2<>1000) or
just set the default color of the cell to yellow.

HTH,
Elkar


"Thomas Homan" wrote:

> All,
>
> Is there a way to access give cell objects from within functions without
> invoking a macro of some sort?
>
> I'm wanting to do something along the lines of:
>
> if (a2=1000, cell(b,2).background=green, cell(b,2).background = yellow)
>
> I know this can easily be done inside of VBA but due to our organization's
> macro security level distributing a macro is a royal pain in the backside
>
> TIA
>
> Tom Homan
>
>
>

[Thomas Homan]

Thanks to the both of you! I always forget about conditional formatting

Tom
"Thomas Homan" <[email protected]> wrote in message
news:[email protected]...
> All,
>
> Is there a way to access give cell objects from within functions without
> invoking a macro of some sort?
>
> I'm wanting to do something along the lines of:
>
> if (a2=1000, cell(b,2).background=green, cell(b,2).background = yellow)
>
> I know this can easily be done inside of VBA but due to our organization's
> macro security level distributing a macro is a royal pain in the backside
>
> TIA
>
> Tom Homan
>