Block cell from filling

Hi ronenhaim,

Can I block cell / calls from filling ?

I am not sure what you mean 😕.

Can I "paint " cell / cells frame in color ?

Yes. Select the cells you want to paint.

Format Panel > Cell > Fill or Border.

Regards,

Ian.

Hi ronenhaim,

In Numbers, you can lock a whole table, but you can't lock some cells within a table.

The usual advice is to have an input table (unlocked) and a results table (locked) containing your formulas.

Regards,

Ian.

Hi ronenhaim,

Here is another take on your question

I want to make some cells to be blocked from accepting data , just to leave them empty.

You can make cells appear to be blank.

A formula can insert "" (NULL, blank) into a cell if conditions are met.

You can change the colour of the cell contents to match the cell fill. It will appear to be empty.

Please reply with your aim (the big picture).

Regards,

Ian.

Hi ronenhain,

Numbers has no way to disable (lock) certain cells in a table.

You can highlight cells that do not require an entry.

Please post a screen shot of a small part of your table (remove, make up or hide personal information first).

A picture paints a thousand words 🙂.

Regards,

Ian.

Hi ronenhaim,

You can't block (lock) cells within a table.

Do you want highlighting ("painting") to show which cells require an entry?

An automatic way to do that requires more information (how often you need to pay for an item).

The simple (manual) way would be to add cell fills (red for no, green for go) as an alert.

Regards,

Ian.