Hi guys, I seek your help please.
Referring to the attached, for each range of B2:B26 & D2:D26, I’m trying to apply conditional formatting when there are three conditions meet:
- If there’s blank cell in the range (B2:B26 for instance)
- Each equivalent cell in range A2:A26 isn’t blank
- If the whole range (B2:B26 for instance) isn’t blank
I’ve reached the stage of conditionally formatting to meet the first two conditions over the two ranges by applying this formula: =($A2<>"")*($B2=""), for the range B2:B26 and =($A2<>"")*($D2=""), for the range D2:D26.
But I’m not able to include the third condition whatsoever, any suggestion here please?