Conditional Formatting Query Results - can't understand instructions?

[lpopa]

Anybody know how to conditionally format query results?

I have read another forum post that says that query conditional formatting is possible, but I can't figure out what they mean.

Post: windowssecrets.com/forums/showthread.php/128835-conditional-formatting-in-and-access-query[/url]

Please help!

I have attached my database to this post.

This database keeps track of projects and their associated tasks & statuses. I created different queries depending on task name( i.e. assignment date, approval date, etc.)

Now, with some of the tasks, if it is overdue, it needs to be highlighted red. If it's cutting it close, should be yellow.

I can't figure out how to set up a conditional formatting rule to address this. So instead I've had to create to separate queries for "red" and "yellow" rules, and display them separately in the Dashboard form.

Can anybody please help me figure out how to use the forum instructions mentioned above, to achieve this, or suggest another solution? Or is what I have done my best bet at this point?

 

[CazB]

Had a quick look at this and I don't think what was posted in that forum would work in your situation - it works where you have numbers that are +ve, -ve or zero. Doesn't apply for dates, as far as I can see - they all just come up as the 'positive' value... and you can't specify 'conditions' beyond that

If, however, you are then displaying those reaults in a form or report.... then you can format however you like (within reason )

 

[lpopa]

Thank you so much for replying!

So are you saying that if I display a query in a form I can do conditional formatting on it? That would work for me!

I just haven't been able to find instructions on how to make that happen..

Any ideas?

 

[CazB]

In a form, yes - although it may depend on the version of Access you are using. I'm on 2007, and this is how it works on mine...
In the form's design view, right click on the control that you want to format, then choose Conditional Formatting
You can add up to 3 conditions... I've attached a pic of sample conditions that may suit your situation...

 

[lpopa]

Oh my goodness, I didn't realize you replied until just now! I had given up on this, and found a workaround instead. Thank you so much for the screenshot. I will use this feature tomorrow!