hi to all
I have filed like,
file no., Client's name, subject, attended by, Re.work,Start Dt, Complection
Dt.,Remarks, Bill

I want to create condition if, Completion Dt. is over it should change the
colour of that row with background automatically. and when i write
"Completion" in remarks field it should change to normal.

and one more thing if bill filed is blank it should create list of that data
into new worksheet.

Thanks in advance.

Tiya