Conditional Formatting work automatically
 

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

Conditional Formatting work automatically
 

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

Conditional Formatting work automatically
 

Thanks Bob Philips for your replay but

When i type the formula given by you it applied to all rows some how it's
not working E.G.

1. If date is more than todays date it also change the colour
2. It work with only first column only when i type Completion in "h Column"
it should remove format form that particular row

pls help me.

Thanks

Tiya

"Bob Phillips" wrote:

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

Conditional Formatting work automatically
 

My mistake, it should be

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

change the G to your date column and the H to your Remarks column


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tiya" wrote in message
...
Thanks Bob Philips for your replay but

When i type the formula given by you it applied to all rows some how it's
not working E.G.

1. If date is more than todays date it also change the colour
2. It work with only first column only when i type Completion in "h
Column"
it should remove format form that particular row

pls help me.

Thanks

Tiya

"Bob Phillips" wrote:

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