Conditional Formatting Arrrggghhh !!

[JimM]

I'm trying to apply what should be a very simple conditional formatting to some cells

D6 has the number 10
E6 has the number 6

H18 is the cell I want to conditional format, I'm doing it by formula so that

=H18>$D$6 paint cell red - this works great, if H18 is 10 or less then the background colour doesn't change, over 10 and it goes red

I've then put in a second condition

=H18<$E$6 paint cell blue - but now any value of H18 less than 10 it paints the cell blue, I only want it to do this if H18 is less than 6

What am I doing wrong ???

 

[Fluff]

That works for me

ZFluff.xlsm
	A	B	C	D	E	F	G	H
1
2
3
4
5
6				10	6
7
8
9
10
11
12
13
14
15
16
17
18								8
19								11
20								5
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H18:H20	Expression	=H18>$D$6	text	NO
H18:H20	Expression	=H18<$E$6	text	NO

 

[steve the fish]

Looks fine to me. Check E6 truely is a number. Test with =ISNUMBER(E6)

 

[JimM]

I don't believe it, Steve's hit the nail on the head!
For some reason it was formatted as text, annoyingly I had checked this and formatted the cell as a number but looks like you have to then edit the cell for the formatting to actually take effect!

Thanks for the help both

 

[Fluff]

Simply changing the format of a cell, does not change the value that the cell holds.

Glad we could help & thanks for the feedback