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)
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:
='Service Stars Done'!E9/5
Thank you for helping me.
Bookmarks