Conditional Formatting on Sheet does not transfer over to report
Basically I have a sheet with data. A row that highlights yellow on a particular condition. This same row does not show 'yellow' in report.
Answers
-
Hi @Pam Parrish
Do you have Conditional Formatting set up or do you have Highlight Changes on your sheet? Highlight Changes is specific to the sheet you're looking at, whereas Conditional Formatting should pull through to the Report.
Could you post a screen capture of your Conditional Formatting rules? I'd like to test out the same format to see if we can identify the cause.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
It's conditional formatting. The 'yellow' highlighted row does not pull through to a report.
-
I've got it working...thanks for the reply
-
One more question. Do you know if the filter on the sheet will pull through to the report?
-
Hi @Pam Parrish
I'm glad to hear that the formatting has pulled through for you, now!
In regards to filters, Sheet Filters are specific to just the Sheet. If you want to apply a filter in a Report, you'll need to create that filter from the top bar menu in the Report itself, see: Create Filter Criteria to Control Data in Report Builder
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I am having this issue. Yesterday, conditional formatting was translating to reports that I made, now the conditional formatting is not translating to the reports. They are highlighted in the sheet, but not in the reports. I am using conditional formatting, not highlight changes.
-
I got it... operator error lol!
Embarrassingly enough, what i had formatted, wasn't checked on what i wanted to display on the report!
-
Hey @tannersukle
Thanks for following up to let us know you resolved this! 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives