And to colour cells based on the content of another cell in the same
row, use that cell in the formula, e.g. when formatting cells C1:J1,
check the contents of cell A1: =$A1=""

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