I can't figure out why rows in my report are colored!

[JenniferMa10]

Hi!

I inherited a project report that has certain rows colored red, yellow, and green I think based on either ship or due date. When I edit the report, there isn't any conditional formatting on those two columns. Any insight into where I am not looking? 

Thank you in advance! 

JM

[skyehansen]

Have you checked all the other columns?

[JenniferMa10]

Yes, I did. Unfortunately no conditional formatting has been applied. 

[skyehansen]

Gotcha, and then just to double check -- how are you checking for conditional formatting exactly?

[JenniferMa10]

Edit Report/Columns (View)/Clicking on the column/Advanced Options

If I am missing something let me know! 

[skyehansen]

so far, so good!

I'm also wondering if any of the columns are in text mode, and if so, do you know what the conditional formatting might look like, while in text mode.

Also just making sure, when you look at your report in details mode, are you accidentally applying a different View at that point (i.e. you're somehow on a view that isn't the report default view)

[JenniferMa10]

I so appreciate your time! 

I have text mode for only Line of Business:

displayname=LOB
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=portfolioID
querysort=project:portfolioID
valuefield=project:portfolio:name
valueformat=HTML

And Requestor or Opportunity Owner: 

column.2.displayname=Requestor or Opportunity Owner (SF)
column.2.linkedname=project
column.2.namekey=view.relatedcolumn
column.2.namekeyargkey.0=project
column.2.namekeyargkey.1=convertedOpTaskOriginator:name
column.2.querysort=project:convertedOpTaskOriginator:name
column.2.sharecol=true
column.2.textmode=true
column.2.valuefield=project:convertedOpTaskOriginator:name
column.2.valueformat=HTML
column.3.linkedname=direct
column.3.namekey=Opportunity Owner Email
column.3.querysort=DE:BRC Opportunity Owner Email
column.3.textmode=true
column.3.valuefield=DE:BRC Opportunity Owner Email
column.3.valueformat=customDataLabelsAsString

 I didn't see any conditional formatting within. 

I thought maybe it had to do with the view as well, but it's default for both filter and view. So stumped!

[skyehansen]

interesting... the only other thing I can think of (before you go to Support) is to have you export your report out, via the kickstart area. In setup there should be a section to export a kickstart, so you would want to go there, select reports, and then type in the name of your report and click to export that one report, and then just upload it here for everyone to look at.

It will export as a zip file, and there's going to end up being one file everyone will want to look at, that is the file containing the view code. But if you upload the whole thing then people can download to and test out your report as well.