Using Formulas to Change Colors

D

Dave Jacoby

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
 
N

Niek Otten

Hi Dave,

Format>Conditional Formatting

--
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
|
|
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Dave Jacoby

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

Dave
 
Top