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
