+ Reply to Thread
Results 1 to 3 of 3

Attendance, if at least x out x are there

  1. #1
    Registered User
    Join Date
    01-01-2022
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    1

    Attendance, if at least x out x are there

    Hello.
    I tried it myself, but can't find anything in the forums or elsewhere. Soo.. Much help is appreciated
    I want to create an attentance sheet. If at least 7/9 people are there, i would like to have one cell change its colour to green and say that the meeting will be hold.

    I hope i got my point across. e

    Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Attendance, if at least x out x are there

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Attendance, if at least x out x are there

    Use Conditional Formatting with formula, for example,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and colour the cell green.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-30-2020, 11:37 PM
  2. Attendance: get the lateness or of workers on different shi
    By biglucky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2019, 01:02 PM
  3. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  4. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  5. attendance log
    By excellionaire in forum Excel General
    Replies: 20
    Last Post: 08-16-2011, 02:48 PM
  6. Replies: 3
    Last Post: 06-12-2011, 02:56 PM
  7. Attendance
    By praveen_khm in forum Excel General
    Replies: 2
    Last Post: 02-02-2006, 04:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1