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 ???
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 ???