Use conditional formatting (FormatConditional Formatting)

Select all row, let's assume they start at 2

In CF, change Condition1 to Formula IS and add a formula of

=AND(G2<TODAY(),H2<"Completion")

then click Format, select the pattern tab, and choose a colour

--
HTH

Bob Phillips

"Tiya" wrote in message
...
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