1. Welcome to NikonCafe.com—a friendly Nikon camera & photography discussion forum!

    If you are thinking of buying a camera or need help with your photos, you will find our forum members full of advice! Click here to join for free!

OT : need help with numbers/excel real quick

Discussion in 'Apple/Mac' started by latazyo, Jul 30, 2008.

  1. latazyo

    latazyo

    Apr 23, 2008
    STL
    I am wondering if anyone knows how I can change the fill color of a cell based on the value in it.

    This is for my budget. If I spend over the allowable amount I want the cell to turn red. If I spend under the amount and save money I want the cell to turn green.

    If anyone knows how to do this on excel, feel free to tell me as well, because chances are it may be similar in numbers

    FIGURED IT OUT, BUT I CAN'T DELETE THE THREAD SO I'LL JUST POST THE SOLUTION IN CASE SOMEONE ELSE EVER WANTS TO KNOW

    Format > show conditional formatting rules

    lol...I fail
     
    Last edited by a moderator: Jul 30, 2008
  2. In Excel, it can be done with Conditional Formatting. It can be found under the Format menu in versions before Excel 2007. Then you enter the condition on the top line and the formatting if something meets that condition. I don't know anything about Numbers... never heard of it in fact. Let me know if you need any more help with Excel.
     
  3. latazyo

    latazyo

    Apr 23, 2008
    STL
    thanks Anthony

    it was basically exactly the same

    Numbers is the spreadsheet software that is part of iWork
     
  4. Gotcha... glad I could help Leighton. So, did I respond after you posted that you already knew?! LOL! I must have missed that.
     
  5. latazyo

    latazyo

    Apr 23, 2008
    STL
    technically you did, but you didn't

    I came back to the thread and there was no response, so I edited it

    when I submitted the edit, you had responded
     
  6. Well, good... then I am not going senile. :smile::tongue:
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.