In Excel, I have conditional formatting that changes the colour of the cell when the formula is removed. =NOT(ISFORMULA(cellnumber)) is the conditional formatting. The formula in the cells is linked to another excel sheet and uses data from that excel sheet. When I break the links from the excel sheet, all of the cells change color because of conditional formatting. I want to break the links, but I don't want all of the cells to change colour. I only want the colour change what was before breaking the links.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional formatting =NOT(ISFORMULA(cellnumber))
- Thread starter Ninad7
- Start date
Special-K99
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 8,544
- Office Version
- 2019
What do you mean by "break the links"?
Upvote
0
Upvote
0
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,591
- Office Version
- 365
- Platform
- Windows
Why are you using conditional formatting to identify your constants (non-formula) values ?
Upvote
0
I want to know which data i have in my main database, and which i dont have. its a template so i share this file with others too and i want to know are they using the values from the database too or they are using there own value.
Upvote
0
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,591
- Office Version
- 365
- Platform
- Windows
If you break the link you are removing the formula which triggers your conditional formatting.
Also if the user keys in a value it will trigger the conditional formatting, so I am struggling with what it will really achieve.
Also if the user keys in a value it will trigger the conditional formatting, so I am struggling with what it will really achieve.
Upvote
0
I need to break link beacuse we send this files to others from different department and they dont have access to our drive, so if we send it to them without breaking the links the values will not show. thats why we have to break the link before, which causes all the cells to change colour which we dont want. Thank you Alex for replying.
Upvote
0
Alex Blakenburg
MrExcel MVP
- Joined
- Feb 23, 2021
- Messages
- 9,591
- Office Version
- 365
- Platform
- Windows
To stop the change in colour you will need to remove the conditional formatting from those cells that currently contain the external links.
Upvote
0
Special-K99
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 8,544
- Office Version
- 2019
Breaking the links...
Can't you use VBA to copy the values rather than the links?
Can't you use VBA to copy the values rather than the links?
Upvote
0
I have never used VBA and dont know how it works.
Upvote
0
