Results 1 to 13 of 13

Another Conditional Formatting question

Threaded View

  1. #9
    Registered User
    Join Date
    07-02-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Another Conditional Formatting question

    Please understand I am not saying your formulas are wrong. I may have a typo or something that is causing the error. It could also be a cell formatting error.

    I am creating a spreadsheet to track awards for an all girl scouting organization my daughter belongs too. The page I am working on is the summary page so a leader can see what badges each girl in the squad has earned and which need to be presented. This is the reason for the formatting. To highlight awards that have been earned but not presented.

    For most badges they are only earned once per level. However the girls earn a star for every X number of hours of service, based on their age. IE 1st through 3rd graders get one star for 5 hours of community service. Since multiple stars can be earned on each level here is whats going on,

    Cell C5 =# of service hours comleted at the tenderheart (1st-3rd grade) level /5 which gives me the total number of service stars that girl has earned.
    In cell D5 the leader enters how many stars have been presented to each girl.

    So if the number of stars earned=number presented then normal format.
    If number of stars earned>number presented black field with white text indicating that girl needs one or more stars presented.
    If a leader enters a number greater than what teh girl earned, then this is an error and I want it to pop out so the leader can correct it.

    So in my sheet (table below)

    C D E F
    5 1 1 2 1
    6 3 4
    C5=d5 no special formatting
    E5>F5 Highlight E5
    c6<d6 error formatting

    I hoe this enables you to get this working for me.

    If it matters C5 format is custom [h]
    D5 format is number
    C5 value is
    Formula: copy to clipboard
    ='Service Stars Done'!E9/5


    Thank you for helping me.
    Last edited by swmwshrk; 07-10-2012 at 10:01 PM.

Thread Information

Users Browsing this Thread

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

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