Conditional formatting

[OKCIrish]

Hello,

I need some help trying to figure out this conditional formatting. I've tried looking at other formulas and implementing them to my situation to no avail. I have the conditional formatting set up as to have anything that is greater than the max ID to go red, however if the max ID cell is blank and there are some recordings taken the cell show's up red. I need help with having the conditional formatting highlight cells in red if there is anything above max ID, and no formatting done if the max ID cell is blank.

Book1
	A	B	C	D	E
1		Max ID			Max ID
2		3
3		ID Taken			ID Taken
4	Item #			Item #
5	1	2		1	2
6	2	3.25		2	3.25
7	3	3.25		3	3.25
8	4	3		4	3
9	5	3.5		5	3.5
10	6	2		6	2
11	7	2.5		7	2.5
12	8	2.75		8	2.75
13	9	3.25		9	3.25
14	10	3		10	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:E14	Cell Value	>$E$2	text	NO
B5:B14	Cell Value	>$B$2	text	NO

 

[DRSteele]

Set up a CndFrmt rule by 'Use a formula....' by first highlighting e5 to e14. Then put in this formula: = (E5>$E$2)*ISNUMBER($E$2)

 

[DanteAmor]

How about:

=AND(B5>$B$2,$B$2<>"")

And:

=AND(E5>$E$2,$E$2<>"")