Forum Discussion
Help to sort out high grade objects
Hi Jessica,
If, as in your example, if you have in AG23 the text "blue" and, based on this and combination of some other criterias you'd like to change the text in the same AG23 on "pink", that's not possible. At least by using formulas. You can't take the value from the cell, make some transformations depends on this cell value and return the result into the same cell.
You may change "blue", "pink", etc in AG23 depending on values in other cells, but not depending on what it was in AG23 before. Or you may add above text in one more cell which will be changed depends on AG23 and other cells values.
I added a picture of the formula. So the cell I want to give me the answer is AH, if the AG is blue and (AI or AJ is above 2). Its all in swedish, sorry about that.
Jessica,
If you check if in AG is the text "blue" and other two cells are above 2 when the formula will be
=IF((AG1="blue")*(AI1>2)*(AJ1>2),"pink","")
If you try to check if AG is in blue color when it doesn't work with formulas.