Colour Rows in Datasheet based on three criteria

[PMK]

I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
completed".

I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
colour.

thanking you in anticipation

PMK

 

[John W. Vinson]

I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
completed".

I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
colour.

thanking you in anticipation

PMK

Yes, at least in Access2002 and later. Select the controls that you want to
change color and use the Format... Conditional Formatting menu option.

John W. Vinson [MVP]