Forum Discussion
Condtional formating is broken/changed when adding rows
Hi, My use of conditional formating works, but it is not otpimal. I wish it could be easier to use for the end user, to avoid errors and mistakes. (Second attempt, simplified version) The Sce...
Can you attach the file (anonymized)? I think your CF formulas are wrong (this is something else than the "breaking up" of the CF rules, that is a bug in Excel)
JKPieterse Herr is the spreadsheet. All data here is just for testing.
- Hmm, not a simple one to answer. I think the key problem is that you're referring to cells on another worksheet and that inserting rows on the main sheet does not affect the cell addresses pointing to the other sheet. But I have a hard time understanding what you are trying to do.
JKPieterse Thank you for looking into this.
First, the table I refere to in another sheet works. that is always a copy of the Blue table (see below). With text from the green table if 2 conditions are correct. AnsattID and the text from the green table.
What the goal is: To change the color in the second table, if i a specified text is found in the first table.
Reason: Table one is for Team leaders. They have first choice, and updte the employe.
Second table is for project managers. If there is no specific on a given day for an employee , they can be used for projects/assigments.
The problem is within Conditional formating. It add/removes rules, and it change the cell where the formula is located in Sheet 2. From B2.
Best Regards
- Geir
