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

 

[Guest]

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

 

[Guest]

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]

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

Tom