Maintaining a rigid conditional format

Marvo

Board Regular
Joined
Nov 27, 2023
Messages
206
Office Version
  1. 2021
Platform
  1. Windows
Is there anyway of making conditional format stick to the original selection of cells?

I had a condition that in E35:E550, should a tick be placed at the right of a number, the cell would fill in green. It worked when initially instigated but as soon as I added a tick to another number (to show it was completed) conditional formatting changed to A1:Z450. I have no data after column P so why it should go to that selection of cells I have no idea. Its driving me nuts.

Many thanks.
 
I've just ticked a box "anyone with the link". Does it work now?
 
Upvote 0
No. Just did it again, same link. I'll have another look.
 
Upvote 0
OK, I have got access, thanks.

The issue is that you have vba code in the workbook that is set to change the conditional formatting range to A1:Z450 whenever any change is made in that worksheet. The code is in the 'Hard' worksheet's vba module as shown below. Perhaps try deleting that code unless you have it there for some particular reason.

1737545776245.png
 
Upvote 0
Solution
Well that's that solved. Thank you Peter, sorry to have been so much trouble, god knows how long that VBA has ben there, the workbook dates back several years.
 
Upvote 0

Forum statistics

Threads
1,226,836
Messages
6,193,243
Members
453,783
Latest member
Chandni

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
Back
Top