Forum Discussion
Colour Fill a cell based of a range of cells if they are blank.
Hi There 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. How would I do this using conditional formatting? Tha...
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 > 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.
- Hi Hans
Thank you so much. It works like a charm.
Warmest Regards
Dickson
