pologoalie8908 :
getochkn :
pologoalie8908 :
Sorry forgot to add: I dont want the words in "B"replaced if "J" is less than 10. Since the wrods in B are there from a copy pasted there before formating is applied
Can't really be done that way, because column B has to have the above formula in it (mine or USA's, both work the same, different approach) in the first place to calculate the answer to show in B. Where would you put this formula then if it's not in B?
in J?
J has the value, 10,20,30, whatever. B has a word, low, med, high. You need the formula "=IF(AND(B1>10,B1<30),"med",IF(B1>30,"high","low"))" in column B in order to change the words in B. you can't put this formula anywhere and have it change B. The worksheet functions can only return a value, not set it.
What you want is programming done in VBA programming. This would let you write a function that would change the values of B based on any cell, etc.
I could do it, but it seems like this is for your work, and no offence, but I'm not getting paid to do this, so I don't have the time to write, debug, etc an entire VBA function to do this. I think you need some Excel training if they are expecting you to do this.
Alternative would be to not change the words in the cell, but you conditional formatting to change the color of the cells in column B based on a value in column J. It wouldn't change the words but you could do, change background to green if J< 10, yellow if it's between 10 and 30 and Red if it's over 30, or whatever, so you can visually look and see, these ones are RED, they are over 30, etc.