Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula HELP!
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 |
#2
|
|||
|
|||
Hello Karen,
This is what you need to put into cell L5, =SUM(IF(J56.45,IF(J5<9.44,1,0),0)) You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get {}, these brackets surrounding the equation if you did it right. Second highlight the L cells you are working with go to TAB PATTERS and choose your color, then click ok and ok again, whever that specific cell in the L colomn see the number one it will make it yellow. Dan Format - Conditional Formatting In the first box choose option "Cell Value Is" In the second box choose option "Equal To" In the third box type in the number 1 Then click FORMAT at the bottom go to "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 |
#3
|
|||
|
|||
Hello Karen,
This is what you need to put into cell L5, =SUM(IF(J56.45,IF(J5<9.44,1,0),0)) You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get {}, these brackets surrounding the equation if you did it right. Format - Conditional Formatting In the first box choose option "Cell Value Is" In the second box choose option "Equal To" In the third box type in the number 1 Then click FORMAT at the bottom go to Second highlight the L cells you are working with go to TAB PATTERS and choose your color, then click ok and ok again, whever that specific cell in the L colomn see the number one it will make it yellow. "Dan" wrote: Hello Karen, This is what you need to put into cell L5, =SUM(IF(J56.45,IF(J5<9.44,1,0),0)) You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get {}, these brackets surrounding the equation if you did it right. Second highlight the L cells you are working with go to TAB PATTERS and choose your color, then click ok and ok again, whever that specific cell in the L colomn see the number one it will make it yellow. Dan Format - Conditional Formatting In the first box choose option "Cell Value Is" In the second box choose option "Equal To" In the third box type in the number 1 Then click FORMAT at the bottom go to "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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |