need help in numbers

Discussion in 'Mac Apps and Mac App Store' started by mrgreeneyes, Apr 1, 2009.

  1. mrgreeneyes macrumors 6502

    Joined:
    Oct 7, 2007
    Location:
    Orleans,Canada
    #1
    hi,

    i am trying to figure a way to notify me when i forget to enter data in specific cells, that need to be filled in.

    i included a screen shot.

    what i want it to show is basically fill in the whole row in red or another color
    when i forgot to input data.

    is there a formula?
    [​IMG]

    if you need me to include more information, plz let me know
     
  2. MiBerb macrumors newbie

    Joined:
    Apr 5, 2008
    Location:
    Montréal, Qc
    #2
    May be what you are looking for

    My Numbers version is in french but if you look under "Format" you should find something like "Show the conditionnal format rules"

    You can apply specific formats to cells to which the rules you define apply.

    I hope this will help you.
     
  3. LtRammstein macrumors 6502a

    LtRammstein

    Joined:
    Jun 20, 2006
    Location:
    Denver, CO
    #3
    Best thing I can think of to help out, without using AppleScript, is under those conditions that MiBerb said, you can have it fill in the cell with something you want.

    I recommend having it filled with "#MISSINGDATA".
     

Share This Page