have you tried conditional formating?
formatconditional formating
-----Original Message-----
I need a cell to change color if the value inside the
cell reaches 50 or
higher.either text or cell shade. just so it catches the
users attention.
im running excel 2000. and i have this currently in the
cell that i want to
aplly this to:
=HLOOKUP(D20,'Hidden Data'!GZ10:HB11,2,0)*MAX(15,E20)
.
|