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: