Forum Discussion
Conditional Formatting based on two cells
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.
This works for if I want to conditionally format one cell based on the value in that specific cell, however I want a conditional format that is based on two cells. So for example if there is a blank in either cell b1 or b2 then both those cells with remain red, however if i type in b1 OR b2 the red colour is removed in b1 AND b2. How do i do this please?