Ask Experts Questions for FREE Help !
Ask
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #1

    Feb 15, 2010, 05:19 AM
    Condition for the session
    DOWNLOAD ATTACHMENT

    S= session number
    P= the presence of session
    1,2,3,4,5... = session order number
    1 (red) or empty= attend or not attend the session

    I NEED:

    Conditional Formatting cell C29 (red background and white font)

    1. If someone fails to attend two consecutive sessions, 2. or three sessions in total

    I think I scored second condition. (Clear Contents of C14 to see)


    Thanks!
    Attached Files
  1. File Type: xls session.xls (16.5 KB, 124 views)
    2. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Feb 15, 2010, 11:05 AM

    I would add a key column to do the tests row by row, then use an updated CF formula to watch the key. Sample attached.
    Attached Files
  2. File Type: xls Session.xls (21.5 KB, 117 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Congress closed session [ 1 Answers ]

Does anyone have a clue concerning this closed door meeting? >Moved from Forum Help<

Session timeout [ 7 Answers ]

Was looking at jet 2 web site when it stopped working, A notice came on the site ( session timeout ) Now I cannot get back on the site without it saying the same thing. Please what can I do ?

View more questions Search