Do not allow data if cell is unchecked

DinaW

Hi,

Is there a way to format a column so that it should only allow contents to be entered if a specific checkbox is checked?

For example: if column A checkbox is unchecked, I cannot enter a date in column B (text should be allowed).

Thanks,

Dina

J. Craig Williams

No.

Any data validation available is by column.

There are no formulas that allow formatting or other user 'actions' other than calculating values which can be used in Reminders or Notifications. 

Craig