Firstly, you people are brilliant.

Secondly,


I have 15 rows that people fill out an order with.
Each row is an item.

Next to the row is a tickbox - when ticked, conditional formatting turns the item row green. This means it has been recieved. The tickbox although floating on the the item row, actually refers to a hidden cell. This hidden cell turns TRUE or FALSE depending on the tickbox status, and the conditional formatting of the item row looks at this hidden cell.

I'm trying to make a macro that:

IF ALL rows that have text in, the corresponding tickbox is ticked, then do a prompt box something like "All items recieved?". A yes then does something (i can do!) and a no does something else.

Please help me with this. I'll name my first born after you!