Select the cells that you want to format, e.g. F1:F20
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell:
=F1=""
(you can see the name of the active cell in the Name box, at the left
of the formula bar)
Click the Format button, and choose a dark fill colour on the Patterns tab.
Click OK, click OK


mcs51mc wrote:
Debra Dalgleish Wrote:

Unchecking 'Ignore blanks' doesn't force users to enter a value in a
cell.So what's the purpose of that check box



Debra Dalgleish Wrote:

... ...to check for blank cells, or use conditional
formatting in conjunction with the data validation.

Conditional formatting is no solution since you can't enter a "IsBlank"
or equivalent criteria, only "Cell value Is" or "Formula Is". Do you
have more ;)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html