An Advanced Tickbox?

[Amnesia_180]

Hey.
Im new to the board, so just saying hi!

Here is my problem:
I am having a bit of trouble with something.
i have 2 sheets.
"Sheet1" and "Sheet2"
Customer details are entered into sheet1 via a userform.
This includes addresses, amount of money, totals etc.
Then, when a button is pressed it copies some of the data into "sheet2". Which is just a long line of things.
It then inserts another row ready for the next set of data to be entered.

However, I want a tick box entered onto the end of each line. If it is not ticked, all the text will be red showing they have not paid the fees. If the tickbox is checked, the text for that line goes green.

Thank you for any help you can give me.
Thanks
Amnesia

 

[SteveO59L]

Use conditional formatting with the linked cell property of the tickbox.


HTH