Color change in cell when > 49.99
 

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)

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)




.