Conditional Formatting on Two Criteria's

[gopherking]

Ok, I have used Conditional Formatting to check the contents of another control in a report to determine if a field should be highlighted so I know that is possible. The problem that I have now is that I need to check two criteria's and am a little stuck considering one of the criteria is to check if the current control is greater than 0. So, I thought that I could use the below:



Expression Is: [Me]>0 And [DevHrsUpdated]<Date()-7

But when I ran the report I was prompted for the [Me] variable. Does anyone have an idea of how to do this? Basically looking for:

1) Current control to be greater than 0
2) [DevHrsUpdated] field to be less than 7 days ago (from current date)

By the way, I am trying to create a Condition that can be used across multiple controls so that I don't have to create a different Conditional formatting for each control (24 per report x 5 reports = TONS O' WORK )

[gopherking]

After some more searching online, I was able to find users with the same request and all identified that there is no means via an Expression in Conditional Formatting to reference the Control it is for unless you use the Field Value Is option (which of course doesn't look at other fields).

So, I had to resort to entering the following in the Expression Is:

[fieldname]>0 And [DevHrsUpdated]>Date()-7

ON EACH CONTROL!!!!!

Sorry to anyone else who is looking for the same solution I was, but if you do find once, please post it here so I can update my work and hopefully help some other poor soul trying to do the same thing.