Bug: Report formatting inconsistent

tobrien3

I have conditional formatting in the sheet based off of this [Hrs Over SLA] column. The conditional formatting is correct in the sheet but incorrect in the reports for only some rows (see circled for example, where -67 is highlighted on some rows but not in others)

 

How does one resolve this issue?

JamesR

Are there any other conditional formatting rules set up?

If so check the order as the Rules work in order and a higher rated rule may be overriding the one that you are expecting.

 

tobrien3

Thanks James. There are additional cond. formatting rules set up but none that would affect that column. 

 

The conditional formatting is correct on the sheet but in the report (pictured) it is incorrect

Shaine Greenwood

Hi,

Try opening the source sheet and saving it again, then open your report back up.

If that doesn't work, reach out to our Support team as this might be a backend issue with the reporting functionality.

J. Craig Williams

tobrien3,

Did this resolved?

I have had Report format issues like this in the past, but did not track it to Conditional Formatting.

Craig