Color change in cell when > 49.99

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color change 1
change color of text when figure becomes minus 1
Change color fill when data in cell changes 3
Change background color of cell based on vlookup in cell 1
Change the color of a cell 7
Change cell color for valid if statement 2
How do I change the color the cell becomes when doing a FIND 4
Excel Can you lock the value of a cell but not the format? 1

Top