Hi
I create the conditional formatting below
I would now copy and paste the 2 cells A1:2 to the next col B and have the below result in red
basically I’d keep the condition, but applied to B2:1
I also removed the $ to unblock the references to the cells but it doesn’t work
Can anyone help?
Thanks
Teo
Thanks fro your txt but I don’t want a range as result of the copy but just move to col B same as done for A, please see below
ok thanks for let me know, if you or others can speak to who develop calc please show this to them so they hopefully make this possible.
i have a calculation with more conditional formattings. every time i use the calculation i copy and paste it on a side to keep the original calculation ‘safe’ untouched and to have also available the calculation for the specific case i’m working on with the copy.
in caes if you know who to show it at developers level I can do it myself cheers
Just add a new sheet, and paste it there.
Can you share it? Maybe the actual behavior for the cell range is not the wrong one.
Thanks Leroy you’re right copying it on a new sheet it works, but I wanted it on the same sheet.
After your message I tried it and it works correctly, which means B2 refer to B1 actually and not to A1, as I wanted, which means the copied part if B2<B1 gives white normal format, while if B2>=B1 gives green cell, try it.
Even if it remains a wrong connection in the cond. format. window, which show the condition on B2 given by A1, but this is not true as I said above
in a few words when I copy and paste I wanted the condition be copied and pasted too, updated to the new cells as it happens for the formulas when you copy and paste.
As you see in the cond. form. manager after simply copy and paste in the ‘Range’ field it appears the group A2:B2 which it should be only B2 and in the ‘Condition 1’ field it remains A1 which should be instead B1
even if now I saw that it works correctly with a simple couple of cells, in my calcs sheet there are more conditions and they get messed up and don’t work properly, keeping the old reference also after copy and paste to another area of the sheet.
It’d be great if this could be fixed by the developers, please let me know if you know how and I’ll tell it to them, or even better if you are one of them
thanks
in the previous screenshot the range shows $k$25, don’t know how happened,
didn’t change anything, just redone it now
No. You wrote that there are more conditional formatting.
Anyway; you must take the first cell of the cell range (A2) to compare with the reference in the condition (A1), and this relative position will be updated to all cells of the range, unless you add the $ symbol to the condition (i.e., $A1) to make part or all the reference absolute.
As i said that’s a simple file just to show it in the easiest possible way.
ok so you’re saying that IN my latest screenshot above in the cond. form. manager ‘Range: A2:B2’ and 'Condition 1: A1 it means that the cond. form. is applied first to A2 and A1 and after is repeated similarly for the ‘Range’ cells so same way for B2 which will be compared now with B1
