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 ...
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.
tauqeeracma , uploading doesn't work now
First select the column or cells you want to apply conditional formatting then click on :
Conditional Formatting --> Highlight Cells Rules --> More Rules --> Format Only Cells With --> Blanks -- > Apply desired formatting.