I have a condition set that changes the fill color to red when my condition is true.
This is on a time field. My bug is that it's like if the condition evaluates each cell in the merged group - the result is the 1st cell is too small so it displays ## the 2nd cell displays the correct time.
If I change the cell to which the conditional formatting is applied and reference ONLY the 2nd cell in the merged cells that my condition is never true because excel seems to consider the merged cell to be named by the 1st cell.
Let me try to clarify... I have G84 & G85 merged (with G84 being the narrower cell). When I click on the merged cell the name box near the top left of Excel shows that my selected cell is G84.
When I apply my conditional rules to the merged cell it is automatically applied to the cell group so $G$84:$G$85.
This causes the smaller cell to display hashtags (##). If I remove the smaller cell for the conditional formatting and make it $G$85 only, then my condition never triggers because for excel (based on the name box) I never enter cell G85 but rather a merged G84 cell.
Any ideas on how to fix this ? Is this by design or a bug with merged cells ? I am using Excel 2016.
Thanks,
Dan
This is on a time field. My bug is that it's like if the condition evaluates each cell in the merged group - the result is the 1st cell is too small so it displays ## the 2nd cell displays the correct time.
If I change the cell to which the conditional formatting is applied and reference ONLY the 2nd cell in the merged cells that my condition is never true because excel seems to consider the merged cell to be named by the 1st cell.
Let me try to clarify... I have G84 & G85 merged (with G84 being the narrower cell). When I click on the merged cell the name box near the top left of Excel shows that my selected cell is G84.
When I apply my conditional rules to the merged cell it is automatically applied to the cell group so $G$84:$G$85.
This causes the smaller cell to display hashtags (##). If I remove the smaller cell for the conditional formatting and make it $G$85 only, then my condition never triggers because for excel (based on the name box) I never enter cell G85 but rather a merged G84 cell.
Any ideas on how to fix this ? Is this by design or a bug with merged cells ? I am using Excel 2016.
Thanks,
Dan