Before I request aid. I am aware of the golden roll of conditional formatting and merged cells. DON'T DO IT. I assure you I do my best not to but there are some spreadsheets that can't be helped when merging is top to bottom. I do apologize.
On to my issues. My 1st issue is trying to get both unmerged cells to receive the format. If $C4 has text in it, then everything to the left need to fill in red it is not filled in. I am not sure how to get the non-merged cells to fill in.
My second issue is similar but in this case, I am looking to do the same thing only with using "?". In the beginning text of $z4 it will start with "?". If there is text to follow it, it wouldn't matter. Just the first character.
Please see link below. (Whats a better way to share workbooks?)
CF Merge Cells
On to my issues. My 1st issue is trying to get both unmerged cells to receive the format. If $C4 has text in it, then everything to the left need to fill in red it is not filled in. I am not sure how to get the non-merged cells to fill in.
My second issue is similar but in this case, I am looking to do the same thing only with using "?". In the beginning text of $z4 it will start with "?". If there is text to follow it, it wouldn't matter. Just the first character.
Please see link below. (Whats a better way to share workbooks?)
CF Merge Cells