I'm having a problem replacing certain values in my sheet. I want to replace the value of the cell with another value in the same row if it is above the latter value and I want to do that for every row, how do I do this?
For example 1, In row 2, in the cell C2 and D2, the value is greater than Z2, so I want to replace C2 and D2 with the value in Z2. And in the next row (row 3), in the cell F3,H3, and L3 the value is greater than Z3, so I want to replace these 3 cell with the value in Z3. I want to do this for multiple rows, how do I go about doing it?
Initially, I was thinking of using conditional formatting to first highlight the cells, and then manually changing the value but isn't it a bit too tedious, because you need to do a new rule for each row? I'm not sure if VBA or something is required as I have no experience in it.
What I want it to be: .
So in the case of my example 2 picture, I wanna get E1 (Which has the value of 5) to be replaced by G1(Which is 4) while I wanna get B2 (which has the value of 11) to be replaced by G2 (Which is 2). Or in other words, I'm trying to replace any cell in each row with row G value. With condition that, that cell has greater value than row G.