Forum Discussion
Solved
Conditional Formatting based on two cells
Hi,
I'm making a document in which I need to be able to conditionally format two cells based on whether one of them is not blank (so it has been filled in with something).
Here is a document attached so I need to conditionally format b1 and b2 so if i write in one of them the yellow color disappears. Same goes for b3 and b4 with the blue.
Many thanks,
Bailey100
You may apply the rule to B1:B2 only and, if you need another colour for the pair B3:B4, create one more rule applying to B3:B4 with similar formula, only change B1 on B3 in it. Or, alternatively, create the rule for B1:B2, after that apply by Format Painter to B3:B4 and change colour for this pair rule.
