Forum Discussion
I need Excell Help
Select the cells that you want to format conditionally.
On the Home tab of the ribbon, select 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 color.
Click OK, then click OK again.
HansVogelaar any text
Select the cells that you want to format conditionally.
On the Home tab of the ribbon, select 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 color.
Click OK, then click OK again.
- Oh my gosh your a genius!
Thank you so much it worked!