This is a question that we were posed at training recently.
First select the data area to be formatted. In the example here, I have selected B2:D7.
Then on the Home tab, in the Styles group, from the Conditional Formatting dropdown, click New Rule.
Select Use a formula to determine which cells to format.
The formula in my case is:
Select your required formatting, then click OK twice.
The columns containing blank cells will be highlighted.
Find out more about our Microsoft Excel training in the London area.
Find out more about our Microsoft Excel training in Wiltshire, Dorset, Hampshire and Somerset.