Results 1 to 5 of 5

Thread: Conditional Formatting: High School Counselor needs help am I using the right feature

  1. #1
    Neophyte Chuckiedev's Avatar
    Join Date
    Feb 2021
    Posts
    3
    Articles
    0
    Excel Version
    2016

    Conditional Formatting: High School Counselor needs help am I using the right feature



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am a guidance counselor and need help.



    Here’s the deal.

    I have an excel spreadsheet with about 2500 students. Some days it’s 2499 and other days it’s 2501. We assign the kids a mental health survey. When we run the report we get all “active” students. Column J says True if the student took the survey, False if they did not. I know three students took the test because my total numbers of true changed over the weekend. I’m trying to find who was true on Feb 8 but not Feb 5. (We asked the vendor to add time stamps but they declined)


    On the February 6th tab I have =A1<>’Feb5’!A1 it worked.

    When I try it on the Feb 8 tab it highlights everyone.

    I just removed three students, and from the source sheet and it no longer worked.

    I want it to compare columns A, B, and C on Tuesday results..
    If A and B are the same on “Tuesday” and “Wednesday”, but C is different I want C to Highlight.(or something)


    Please note, Chuck dropped out of school.. I think he is smoking pot down on the corner.

    Tuesday
    Name ID Took Test
    Mary 1234 False
    Mark 5678 False
    Luke 2468 True
    John 1357 False
    Chuck 9119 True
    Bob 1991 True

    Wednesday
    Name ID Took Test
    Mary 1234 False
    Mark 5678 True
    Luke 2468 True
    John 1357 False
    Bob 1991 True

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,001
    Articles
    0
    Excel Version
    365
    I've got some ideas (possibly using VLOOKUP) but not sure about some of the details; you talk about running a report, so does that report produce a new Excel sheet, perhaps a new Excel workbook?, or something else (it might be easier if it is 'something else' by the way)?
    Does the ID by itself uniquely identify the student - does that ID stick with them, and all new students get a new ID which has never been used before?
    If you are getting a new worksheet everytime, are you wanting conditional formatting added to that new sheet?
    Are macros (vba) allowed. You're using nothing later than Excel 2016 right?

    To save us lot's of time and to stop us guessing wrongly, you should really attach a workbook - I'll wait for that…

  3. #3
    Neophyte Chuckiedev's Avatar
    Join Date
    Feb 2021
    Posts
    3
    Articles
    0
    Excel Version
    2016

    Reply

    Because we are talking student data I really can't upload the workbook.

    I mocked one up.

    I am using a school computer, limited permissions.. never tried macros.

    The list attached is 6 people.. my actual list is 2745.

    Every day I run a new report with 274X

    I copy that spreadsheet to a new sheet in my master workbook and compare monday to tuesday, tuesday to wednesday.
    Attached Files Attached Files

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,001
    Articles
    0
    Excel Version
    365
    There's conditional formatting on Sheet1 to highlight those rows where either Column E has changed or a student doesn't exist on Sheet2.
    The formula used in conditional formatting was developed in cell P2. You do not need this column at all - it's there to show workings.
    Attached Files Attached Files

  5. #5
    Neophyte Chuckiedev's Avatar
    Join Date
    Feb 2021
    Posts
    3
    Articles
    0
    Excel Version
    2016

    Thank you.

    Thank you. I will take this and run.

Posting Permissions

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