Colour Fill a cell based of a range of cells if they are blank.

Question

Hi There&nbsp;I am have a table and I would like to Colour FIll (Yellow) cells in column G only if both the adjacent cells H and I are blank.&nbsp; How would I do this using conditional formatting?&nbsp;Thanking you in advance for your assistance.&nbsp;Warmest regards&nbsp;

hansvogelaar · Answer

DicksonK10&nbsp;
Let's say you want to apply this to G2:G100.
Select this range; G2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting &gt; New Rule...Select 'Use a formula to determine which cells to format'.Enter the formula
=AND(H2:I2="")
Click Format...Activate the Fill tab.Select yellow as highlight color.Click OK, then click OK again.

dicksonk10 · Answer

Hi HansThank you so much. It works like a charm.Warmest RegardsDickson

Forum Discussion

Colour Fill a cell based of a range of cells if they are blank.

Share

Resources