Alternate Column Color Based on Date Range, and Conditional Text

[bruce_sorge]

Greetings,

I have attached a spreadsheet to show the information I am referring to.

1. I need to color the columns based on conditions. If the Complete field has an x, then it should be blue. The first column that doesn't have an x in Complete is the step the item is at, and it should be green. If the column has exceeded the baseline in days, it should be red.
2. I also want to show a text box above the table that shows the step that the item is at based on the first column for Complete being blank. (I am basing display of table data based on GetFieldSelections function) 

Thanks in advance

Bruce

[lorenzoconforti]

Hi Bruce, can you share a sample application with this data?

It would be easier to help you

[bruce_sorge]

Sure, attached is my .qvd file.

Bruce