Do not allow data if cell is unchecked

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

Find more posts tagged with

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