How do I change the BackColor based on the value o

[secowu]

How do I change the BackColor based on the value of the Status field?

TKS

How_do_I_change_the_BackColor_based_on_the_value_of_the_Status_field.rar

[secowu]

xlbo, sorry if I've confused you but the same question is being asked in the Access thread causing confusion there as well.

Yes,This Question about CONDITIONAL FORMATTING of MS Office Suites

Both in Access and in EXCEl,I've the same question

& now,i want to know:

1.How do I change the BackColor based on the value of the Status field? In EXCEl ,More than 4's CONDITIONAL FORMATTING

2.1.How do I change the BackColor based on the value of the Status field? In ACCESS datasheet view (Form) ,More than 4's CONDITIONAL FORMATTING

Thanks your help extremely!

Now,1st,How do I change the BackColor based on the value of the Status field? In EXCEl ,More than 4's CONDITIONAL FORMATTING ?

Like These Samples:

CONDITIONAL FORMATTING

CONDITIONAL update today Lack of Info. Delivery OK Cancelled Returned Goods Hold

Color Index

(Every ONDITIONAL has own Color remark)

Data Samples:

Product Date Status

SK12588 22-Aug update today

BK01288 28-Aug Lack of Info.

DKFIIF 02-Jue Delivery OK

SD0128 16-May Cancelled

DFG63258 26-Aug Returned Goods

12588G 12-Otc Hold

And,the Col. "Status" is the Judgment basis

Such as:

if The "orange" represents "Hold"

if Status= Hold,then set that Rec.'s BackColor orange...