try putting what yyou would want ented in J5 doesnt meet the criteria instead
of "else"
=if(and(j56.45,J5<9.44),1,"else")
selecty cell L5
<format<conditional format
formula is =and(j56.45,J5<9.44)
and change format to yellow
"Karen" wrote:
Would some please help me with this formula? I want the formula to reference
cell J5 - This is what I need: If cell J5 is 6.45 and <9.44, place a number
1 in cell L5 and turn cell L5 yellow.
How can this be done? Thank you
|