0

Conditional Formatting Advice Please

The screenshot here shows I having grouping selected and a count #.   For sake of clarity, I would like to emphasize the #Count so that it is more prominent for the reader when records are exported as Excel and printed as a PDF.  I'm thinking of using Conditional Formatting but not sure how I would structure the Condition.  I cannot use ">1" because the count could be "1".  I could insert a column with a formula but not sure how I would structure the formula to only display the "count" figure.

The # in the screen shot is not displayed in an export which is a pity.

Any ideas?
 

7 replies

null
    • Mel_Charles
    • 7 mths ago
    • Reported - view

    Could you not use " > 0" ?

    or you could add the formula

    and put

    count (QUANTITY) >0

    this would return a true (yes)

    then you could count that formula Coloumn

    not elegant - just thinking off top of my head whist having a sandwich

    but i think that only gets you back to wher you are anyway

      • Alan_Cooke
      • 7 mths ago
      • Reported - view

       No, because the Quantity will always be > 0.  I want to emphasize the #3. #1 etc to pop

      • Mel_Charles
      • 7 mths ago
      • Reported - view

       what about ">=1"?

      • Alan_Cooke
      • 7 mths ago
      • Reported - view

       My post already covers that option.  The same issue applies to any number because whether count or actual quantity any formatting would apply.  If there was a way of checking either the right most column or left then I could perhaps use that.

    • Mel_Charles
    • 7 mths ago
    • Reported - view

    I do something similar to highlight proof days

    ie if over x days pop a proof flag (and you could also colour them for your qty's

     

     

    • Alan_Cooke
    • 7 mths ago
    • Reported - view

    I have managed to find a solution but in reverse.  I can change the colour of the actual quantity which sadly does not export.  I guess a macro in Excel will be the solution.

    • Alan_Cooke
    • 7 mths ago
    • Reported - view

    Any conditional formatting applied in Ninox does not export - not even a colour.

Login to reply

Content aside

  • Status Answered
  • 7 mths agoLast active
  • 7Replies
  • 87Views
  • 2 Following