MrExcel Publishing
Your One Stop for Excel Tips & Solutions

no blank cells


Posted by Ferda on February 04, 2002 6:57 AM

I am designing a spreadsheet where i want all the fields to be filled with a value... how can i enforce a 'no blank cells please' rule without the use of macros... maybe color in the the cell in red as a warning... how can i do this... please help


Posted by Steve Hartman on February 04, 2002 7:24 AM

You can do this with conditional formatting. highlight the first cell in your range. Click FORMAT > CONDITIONAL FORMATTING. Change cell Value Is to Formula Is. Assuming the cell you are in is A1 put =A1="" in the formula field. Click on Format... button, then click pattern tab and choose you background color. Click Ok twice to exit the dialog. Then Copy > Special > Formats to the rest of the cells you want to be sure have entries.