When I cut and paste a function from cell B2 to B3, Excel updates the function with new cell numbers
Cut =IF(B2>A2,"true","false") from B2
Paste to B3 becomes = IF(B3>A3,"true","false")
Is there a solution to cutting and pasting conditional statements so that Excel updates the cell numbers?
If not, is there a way to change the color of a cell using an IF function?
If not, I will have to edit 10000 conditional statements.
Thanks
Cut =IF(B2>A2,"true","false") from B2
Paste to B3 becomes = IF(B3>A3,"true","false")
Is there a solution to cutting and pasting conditional statements so that Excel updates the cell numbers?
If not, is there a way to change the color of a cell using an IF function?
If not, I will have to edit 10000 conditional statements.
Thanks