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