1. Sep 21, 2005 #1

   djeipa

   

   Hello, can you tell me hjow to highlight a cell with IF ?
   eg IF(A1>100,HIGHLIGHT,NotHIGHLIGHT) <<<<<< somethin like that ????
   
   Thank you

    

   djeipa, Sep 21, 2005
2. 
   Phys.org - latest science and technology news stories on Phys.org

   • • Game over? Computer beats human champ in ancient Chinese game
   • • Simplifying solar cells with a new mix of materials
   • • Imaged 'jets' reveal cerium's post-shock inner strength
3. Sep 21, 2005 #2

   djeipa

   

   Highlight,
   I mean to change the color of a cell automaticily, thanks

    

   djeipa, Sep 21, 2005
4. Sep 21, 2005 #3

   Dr Transport

   

   Science Advisor

   Gold Member

   Look in the format cell functions.....

    

   Dr Transport, Sep 21, 2005
5. Sep 22, 2005 #4

   djeipa

   

   Thank you doc, it works perfectly
   I am thinking bout how to change even the color of my text in the cell, is there any way taht can do with IF??? thanks guru

    

   djeipa, Sep 22, 2005

• Log in with Facebook
• Log in with Twitter

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in