I have a sheet called ‘Email’ in which I reference cells from the sheet ‘CL Upcoming’. What I am finding is that when I add new rows to the ‘CL Upcoming’ sheet that the new rows in the ‘Email’ sheet are not showing. See row 43.
I can confirm that the data is pulling over, however. The highlighted cell on the right below was copied from the left highlighted cell.
Therefore, I can conclude the issue has to be related to my conditional formatting, where I essentially blank out a cell if the value is blank.
What I can’t figure out is if my conditional formatting formulas are off or if I am doing something else wrong. Does anyone have any thoughts as to what I am doing wrong?
