You’re offline. This is a read only version of the page.
49
Hello,
I will try to explain my requirement before asking my question:
I have a working ER report.
Sometimes URLs need to be embedded into the ItemId in the report lines (not always).
I managed to do this, by using 2 hidden columns where I added the ItemId, and URLs in separate cells. The report field has the following logic: IF(Url="", ItemId, HYPERLINK(ItemId, Url))
So far everything is working okay.
The second part of the requirement has to do with formatting. If there is a URL, the ItemId should be Blue and underlined (standard Hyperlink format), but if the URL is empty it should be normal format (black no underline).
I tried doing that with conditional formatting in the Excel by changing the format depending on if the URL is empty or not.
The problem here is that formatting rules don't seem to be duplicated for additional rows created in ER for the report.
What do I need to do, that (independent of row count) the formatting is normal (black no Underline) when the line ItemId doesn't have a URL? is that even possible at the moment?
Best regards
Thimo F.
Hi Thimo,
I'm not sure this solves your problem; you can set the conditional style in Excel: open an EXCEL table report, select the specified column, click on the menu bar "Start - conditional formatting - highlight the cell rules - equal to" then add your custom rules.
Share
Report
All responses (
Answers (
