Conditional formating

[Garswood]

Hi can anyone Help?
I want to set a fields background colour dependant on status. My problem is I have a table containing 2 columns "Description" and "Status", I want to put the description in a continuous form and set the background colour dependant on status.
I have used conditional formatting on the status field to check that it works but cannot get it to work on the description field ( I have also tried setting in vba although I am a newbie to this). I am sure I am missing the obvious and would appreciate any help.

Regards
Pete

 

[Carol]

Sounds as though you have A2K. Try this, click on your description field, and click on Conditional Formatting.

Condition 1: Field Value Is Equal To Status
Condition 2: same
Condition 3: same

Replace Status to the actual Status Value.

 

[Garswood]

Carol,
thanks for the quick response.
I'm not sure if this is what you meant but I just figured it out by using an expression and it works a treat.

Click on description field.
Condition 1
choose 'Expression Is' from drop down list in the next field type
[Status] = "status 1" where status 1 = required value.

Thanks

Pete