View Single Post
  #2   Report Post  
 
Posts: n/a
Default

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)




.