Using Formulas to Change Colors

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave Jacoby - 03 Jan 2007 18:58 GMT

Can you use formulas to change the shadow of the cell when certain
conditions are met? I am very good using Excel, but have never tried this
and I cannot find any documentation. So, I think that it just cannot be
done.

Dave

Reply to this Message

Niek Otten - 03 Jan 2007 19:05 GMT

Hi Dave,

Format>Conditional Formatting

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Can you use formulas to change the shadow of the cell when certain
| conditions are met? I am very good using Excel, but have never tried this
| and I cannot find any documentation. So, I think that it just cannot be
| done.
|
| Dave

Reply to this Message

Bob Phillips - 03 Jan 2007 19:09 GMT

Shadow or colour? If the former, I have no idea what you mean. If the
latter, Try Format>Conditional Formatting.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Can you use formulas to change the shadow of the cell when certain
> conditions are met? I am very good using Excel, but have never tried this
> and I cannot find any documentation. So, I think that it just cannot be
> done.
>
> Dave

Reply to this Message

Dave Jacoby - 03 Jan 2007 19:19 GMT

I was talking about changing the color of the box. Thanks, that helped a
lot.

Dave

> Shadow or colour? If the former, I have no idea what you mean. If the
> latter, Try Format>Conditional Formatting.
[quoted text clipped - 6 lines]
>>
>> Dave

Reply to this Message