3

I have applied conditional formatting to a Pivot Table. In the Excel desktop application, everything works fine. However, the conditional formatting does not appear in Excel Web Parts or Web Page Viewer. If I download the Excel document from either part and open the document in the desktop application, the formatting appears again. I have tried loading the SharePoint page in Chrome and IE.

Is it not possible to view conditional formatting on SharePoint? If so, are there any workarounds to highlight rows if a date is a certain value so that the formatting appears in SharePoint?

  • Conditional Formatting should work. However, there are some limitations (fonts, some border lines, certain calculations, etc.) that may be causing an issue for you. Here's a list of the differences between viewing Excel online vs the Desktop client: support.office.com/en-us/article/… – theChrisKent May 30 '17 at 17:09
2

I can't explain it, but it seems I was experiencing a bug. I changed one of the rules to make the grid lines red instead of making the fill red, and all of the sudden all of my rules starting working on SharePoint.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.