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
-
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
-
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
-
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.
-
Any conditional formatting applied in Ninox does not export - not even a colour.
Content aside
- Status Answered
- 11 mths agoLast active
- 7Replies
- 95Views
-
2
Following