Forum Discussion
Color with Conditional formatting
Select B17:D17 (or further to the right if you wish).
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'not equal to' from the second drop down.
In the box next to it, enter the formula=""
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
Select B17:D17 (or further to the right if you wish).
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'not equal to' from the second drop down.
In the box next to it, enter the formula
=""
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.
