Jul 31 2019 02:33 AM - edited Jul 31 2019 02:55 AM
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
Jul 31 2019 02:41 AM
Jul 31 2019 02:56 AM
Jul 31 2019 03:01 AM
Jul 31 2019 03:27 AM
@tauqeeracma , uploading doesn't work now
Jul 31 2019 03:47 AM
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.
Jul 31 2019 04:22 AM
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?
Jul 31 2019 04:44 AM
Yes you can do conditional formatting based on two cells. Please apply below in Cell B1:
And this in B2
Thanks
Jul 31 2019 06:47 AM
Hi, this works for blanks in both but if you input a number or text into one of the cells the format does not clear, until you have wrote in both. Do you know how to solve this,
Thanks!
Jul 31 2019 07:14 AM
You may use one rule with the formula
=LEN(B1&OFFSET(B1,MOD(ROW(),2)*2-1,0))=0
applied to entire column B (starting from cell B1)
Jul 31 2019 08:19 AM
Thanks, is it not possible to do it for selected sells such as maybe b1 and b2, as i need a separate one for b3 and b4?
Jul 31 2019 08:50 AM
SolutionYou 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.
Jul 31 2019 08:50 AM
SolutionYou 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.