Conditional formatting rules increase by copy/paste

selant

Board Regular
Joined
Mar 26, 2009
Messages
109
I have conditional formatting in some of the cells in my workbook. I make the worksheet protected with a password however when a user copy and paste from cell to another cell, the conditional formatting rules are increasing. I want the conditional formatting rules to be constant. How can i fix these rules ?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

rbrhodes

Board Regular
Joined
May 25, 2007
Messages
69
Hi s,

What do you mean when you say "the conditional format rules are increasing" Afraid I don't quite get it.
 
Last edited:

wsjackman

Well-known Member
Joined
Jun 19, 2008
Messages
2,465
if you mean that the cells in the conditional format formuls are changing, add the $ in the formulas to make them absolute

for example change A1 to $A$1
 

selant

Board Regular
Joined
Mar 26, 2009
Messages
109
if you mean that the cells in the conditional format formuls are changing, add the $ in the formulas to make them absolute
for example change A1 to $A$1

Hi the problem is not making the formulas absolute with $ sign, i think..

Here is the original rules window before copying any cell to another.. These are the rules, i want to keep as is..

displayimage.php


However, here is the same window after copying Cell G/15 to Cell I/15, the rules increase and if each time a cell is copied to another, the rules are increasing :

displayimage.php


What results may occur if i cant solve this problem ? Or how to avoid..
 

wsjackman

Well-known Member
Joined
Jun 19, 2008
Messages
2,465

ADVERTISEMENT

if you copy a cell with conditional format when you paste it onto a new cell that cell will have conditional formating also

what you can do
copy the cell
select the cell you want to paste into

paste special formulas or values
 

selant

Board Regular
Joined
Mar 26, 2009
Messages
109
if you copy a cell with conditional format when you paste it onto a new cell that cell will have conditional formating also

what you can do
copy the cell
select the cell you want to paste into

paste special formulas or values

Hi wsjackman, first of all thank you very much for your kind response and helps. I am aware that when copying pasting a cell, it carries the conditional formatting and a solution is the way you suggest, pasting special.. The point is that, this workbook will drive through 4 different workers and come back to me. So i can not control each worker which some of them are abroad. So i am trying to take some steps to prevent possible errors. Locking the workbook is ok it helps me but i dont seem to solve this conditional formatting issue when copying a cell. I thought about putting some script to avoid copying cells but its nothing useful for the type of my trouble i guess. Thank you again and regars.
 

rbrhodes

Board Regular
Joined
May 25, 2007
Messages
69
Perhaps a macro that prevents Paste if Conditional formatting is present?
 

Forum statistics

Threads
1,136,338
Messages
5,675,187
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top