Need Help with Conditional Formatting

[buddyleee5]

I have a report generating from a query that has the following data:

Name...Partner...Status
Hospital...CML...Open
Mall...CML...Open
Store...CML...Closed
Hospital...MDL...Open
Mall...MDL..Open
Hosital...JRL...Open


and I want to alternate the row highlights based on the partner column- so every row with the partner CML is white then the rows with MDL are gray then the rows with JRL are white.

Is this possible? There are 20 partners and they may or may not be included in the report so I can't just use the list and alternate the format arguments for each partner having their own color

 

[pr2-eugin]

I think this article will help you get started.. http://office.microsoft.com/en-gb/a...using-conditional-formatting-HA010208133.aspx

 

[buddyleee5]

I think this article will help you get started.. http://office.microsoft.com/en-gb/a...using-conditional-formatting-HA010208133.aspx

That deals with alternating the row colors, not alternating based on field value.. I had read that before

 

[pr2-eugin]

Did you check : Add conditional formatting by using an expression? It seems to look like what you want to do..

 

[buddyleee5]

What would you suggest my expression be? I believe it would require me to reference the previous cell and due to the way access works I don't know how to do that

 

[David R]

Rather than alternating rows, you want to compare if [Partner] is the same as it was in the previous row. If it is, keep the same color code. If not, start the alternate color code.

 

[buddyleee5]

Rather than alternating rows, you want to compare if [Partner] is the same as it was in the previous row. If it is, keep the same color code. If not, start the alternate color code.

Correct, but how do i reference the previous record on a report i guess is my real question

 

[buddyleee5]

anyone.... bueler

 

[David R]

Further down the page Paul linked to, there is "Use an expression to apply conditional formatting to one or more controls". That should do what you want.

Strike that. What controls the order of your rows?

 

[buddyleee5]

Further down the page I linked to, there is "Use an expression to apply conditional formatting to one or more controls". That should do what you want.

Strike that. What controls the order of your rows?

I have a sort starting with Due date then by partner

 

[buddyleee5]

up to the top

 

[David R]

How are you with VBA? I think you're going to have to use a recordset to accomplish this, unless someone else has a better idea.