Where 19 is just short and would not warrant a cell formatting as an example. A swing difference of 20 or more has to be achieved to rate a green formatting in a smaller sample size of 90 (between 50-100 for the criteria above). The reason for this is everything is dependent on the weighting of the sample size ie.cell G1 above.
#Openoffice conditional formatting based on multiple cells how to
Does that mean I have to assign values to the positive condition=3 for green, and negative condition =2 and 1 for no formatting, could you show me how to add that to the formula's please? Sorry, I know this is all very confusing All I'm trying to do is conditionally format a cell or range of cells, when that cell has a certain value, and another referenced cell has certain range of values. I think this will work, except I either have to figure out how to assign the positive conditions as true (not sure how to do that in the conditional formatting rules, I looked and looks like I can only set the conditions as >, = or <= I don't see an option for just = true. I guess all I have to do now is, have it format green with the positive condition being true, and red with the negative condition being true, else leave it alone.
I'm new to formula's in excel, is there a better shorter way? Thanks much in advance. I started working on this formula in the conditional formatting new rule creation IF(AND($G$1>=1000,$A2>=3)3,if(and($G$1=>500,$G$1=5)3,if(and($G$1>=100,$G$1=10)3,if(and($G$1>=50,$G$1=20)3.and so on but that formula would be really long and I haven't even gotten to the negative conditions yet. and no formatting to the cell if none of these conditions are met (2), and a red formatting to the cell (-1), if the cell A above is -3 or -5 or -10 or -20 or -30 but with the other referenced cell as the same 1000,500,100,50,25 ranges not negative. All these conditions should have a final value of (3) so I can assign the condition of green formatting to the cell. And again, if the value of the cell is 20 or higher, and the other cell's value is less than 100 but greater than or equal to 50, and finally if the value of the cell is 30 or higher, and the other cell's value is less than 50 but greater than or equal to 25. Same again, if value of cell A is 10 or higher, and the other cell's value is less than 500 but greater than or equal to 100. Also same case, for the same cell, if the value of cell A is 5 or higher, the cell should be green, but only if the value of another cell is less than 1000 but greater than or equal to 500. Example: if the value of the cell A is 3 or higher the cell should be green, but only if the value of another cell is greater or equal to 1000. Hi, I'm trying to set a cell conditional format based upon its cell value and another cell value.
0 kommentar(er)
