Allow conditional formatting using more than one column - an AND statement.

[#1]

Description - Allow conditional formatting using more than one column - an AND statement.

Why is this feature important to you - This seems like such a basic capability nowadays so I'm baffled as to why this cannot be done.  It's important because when you don't include the % complete column it highlights tasks that are complete, which makes no sense.  There are tons of other things someone might want to do and without the ability to write this kind of logic the conditional formatting is in my opinion almost useless or close to it.

How would you like the feature to work - I would like to create the following conditions and similar conditions:  The task planned completion date column is less than today, and the % complete column is less than 100%.

Current Behavior - Highlights tasks that are complete, which makes no sense.

I may not have worded this in the best manner, but hopefully what I'm suggesting will be understood.  I cannot be the first person to ask for this functionality.

[#2]

I think you can already do this. That's probably why no one else has asked for it. Can you post a screenshot of exactly what you're asking for? You can just photoshop a screenshot or something so it's easily understandable.

[#3]

@RandyRoberts

Tell me if this helps:

IF "Planned Completion Date" is LESS THAN $$TODAY AND "% Complete" is NOT 100% THEN "turn the row red" or some other conditional formatting of choice.

does that help, is that clear?

[#4]

My first thought and easiest way would be a calc field on the object that says "IF "Planned Completion Date" is LESS THAN $$TODAY AND "% Complete" is NOT 100% THEN "TRUE"

Then a report column saying if My Calc Field = "True" then colour the row Red.

Still wondering if there's a way to put an AND in between column rules so they don't execute from the bottom up.