I don't think you can conditionally format row color, but you could make a calculated field something like:
DATEDIFF('day',[Your date],today() )>90
This will result in true if the date is more than 90 days old. Drag this the color shelf.
(finally giving back for my 100th post...)
This helped! Do you know how I might focus this formula on only a single row of data within a set? The last formula worked, but affected the entire table rather than a specific row I was looking to affect.
And if anyone knows if it still might be possible to shade the row rather than color the text, I'd be interested in that info too.
Sounds to me like you might have put the calculated field on the wrong shelf, or something like that. Can you post an example to make it easier for us to work out what's gone wrong?
On the question of shading the background rather than colouring the text, there is a trick that lets you do that for your measures by choosing a mark type of bar and putting measure values on the text shelf. There's an example and links in an old thread here:
If you can post sample data or a workbook of what you have so far, I can make a demo of how you can adapt the technique Richard linked to for your specific situation.
Thanks for the responses!
I've attached a workbook with some sample data and the formula from the original response to my post. In this sample data set I'd like to have highlighted only the data in "Sample B" that is less than 90 days old.