If Statement Overwhelm

R

RalphSE

Hi All,

I said to myself "I can figure this out, don't bother those nice peopl
on the Exceltip board". That was 3 hours ago, I give up, mercy!!

Here's what I need:

there is a value in cell L2 and a value in cell M2. I am trying t
write an IF statement that will do the following:

*if L2 <.615 and M2 >.615 then say "YES" making that cell b
highlighted green would be an added beautiful thing but not necessary

*if L2 > .49 and M2 < .49 then say "NO" making that cell be highlighte
red would be an added beautiful thing but not necessary

*any other possible combinations other than the 2 mentioned above don'
do or say anything, LOL

would greatly appreciate some help with this!! :
 
Top