Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld 2020: Live Event Cancelled. Stay tuned for information on our virtual event. LEARN MORE
Highlighted
Contributor II

NPrinting Excel Report: Conditional Formatting

Hi,

I have a column in my Excel sheet on which I want to apply Conditional formatting. I am able to do it if the values is negative or positive. But now the challenge is that I have to compare the value with another number.

For Example: I have a column named PR. If PR>.375 the value should be displayed in Green color otherwise red.

Can anyone help me with this issue?

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: NPrinting Excel Report: Conditional Formatting

Hello,

Highlight the column

  1. Navigate to conditional formatting
  2. Highlight Cell Rules
  3. More Rules
  4. Format only cells that Contain
  5. Cell Value --> Greater Than --> 0.375
  6. Format --> Fill --> Add your color
  7. Repeat the above steps for <0.375

Thanks.

View solution in original post

1 Reply
Highlighted
Valued Contributor

Re: NPrinting Excel Report: Conditional Formatting

Hello,

Highlight the column

  1. Navigate to conditional formatting
  2. Highlight Cell Rules
  3. More Rules
  4. Format only cells that Contain
  5. Cell Value --> Greater Than --> 0.375
  6. Format --> Fill --> Add your color
  7. Repeat the above steps for <0.375

Thanks.

View solution in original post