Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel question1

  1. Sep 21, 2005 #1
    Hello, can you tell me hjow to highlight a cell with IF ?
    eg IF(A1>100,HIGHLIGHT,NotHIGHLIGHT) <<<<<< somethin like that ????

    Thank you :smile:
  2. jcsd
  3. Sep 21, 2005 #2
    I mean to change the color of a cell automaticily, thanks
  4. Sep 21, 2005 #3

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    Look in the format cell functions.....
  5. Sep 22, 2005 #4
    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
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook