Another Conditional Formatting question

I can't figure out the right way to do this

If cell I5=0 (or blank) Normal format
If cell I5>0 and/or >J5 Format white font on black background
If cell I5=J5 Normal format
If cell I5<J5 should never happen, so I need an error alert if this happens.

None of these will involve negative numbers.

I tried to keep it simple using =(i5>j5) but 0 is highlighted if j5 is blank, and this lets j5>i5.

I tried playing around with the formulas and couldn't get them to work. Please let me know how to do this. Thanks.

How about this?
Cell Value =or(i5=0,I5=J5) ->No Format
Cell Value = or(i5>0,I5>J5) -> Black fill & white text
Cell Value < $J$5 -> Red Font

Well, Did you change the references for the other cells? If you are just checking against $D$5, then it's doing what it's supposed to. You can take the absolute references out of there, that was just a copy/pasta thing. Upload another photo showing the conditional formatting rules of the other cells in question.

I think you don't understand:
Conditional Format only works on the cell with that format.
If you set conditional formats for cell I5, they do not effect other cells.

You would have to set some other conditional format conditions for cells E5 and G5

Mshale's and my formatting work for your original condition.

Explain what you are trying to do. ie which cells need formatting?

Give a better explanation

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:

Please Login or Register  to view this content.

Thank you for helping me.

Not to tell you what to do but I was a boy scout leader and we had software tailored for that function and it was inexpensive. Surely girl scouts have the same. I recommend that approach.

If you still need help perhaps someone else will step up as I am having a hard time following your explanation. Sorry