Adding Display Zero as Dashes to Custom Excel Number Format
Hi There, I am currently using the following custom format cells for my number display: #,###.0,;[Red](#.0,); I would like to add to this, so that when a value is "0", a dash "-" is displayed instead of the zero. Thanks in advance for the help! EmmaDonut/Doughnut Chart - Multiple Series
I have created a doughnut chart with multiple series (represented by multiple rings - see charts below). Each ring is divided into 6, the colour of which corresponds to one of three options (yes, maybe and no). I therefore want the colour of the chart to represent this clearly (green, yellow and red), making each ring comparable - i.e. so that the entire chart is made up of only three colours. When I format the legend entry to edit the colours, it only applies the changes to the inner ring/the first series. I am able to manually edit the colour of every other ring segment, however with a lot more data to add this will take a very long time and mean that I am no able to easily edit it should I wish to change the colour again. I imagine there is a way to do this in one simple step, however am unable to find it. Does this make sense? Any help would be greatly appreciated. Please let me know if I need to make this clearer/explin further. Thanks! Chart 1 - the automatically generated chart where only the colours of the inner ring have changed as I have edited them. Chart 2 - I have manually edited this chart to show how I want the chart to look - i.e. I want any colours that I change to apply to all seriesExtra-thick borders, thicker than those available?
Hello, how to create even more thicker (than those avaliable per click) line styles in "Format Cells->Border->Line->Style. Question is - how can I create the border that is thicker, or is it possible to create my own border line style - for example using Paint to draw it? Thanks for any advice :)How can I apply formatting uniformly across multiple sheets/tables?
Alright, I will try to make this brief and concise and I appreciate any help anyone is willing to give. Here's my situation: I have a bunch of PDF files that contain data I need to manipulate (some auditing reports). To achieve this, I exported the PDF files as .xls files via Adobe Acrobat Pro DC. Now, this works pretty well - better than I thought it would honestly. However, the issue is that I'd like to apply additional formatting to these (newly exported) worksheets. Ideally, as the title says, I'd like the formatting to be uniform for all worksheets and, ideally, I'd like to automate this process. My first thought was to simply record a macro, where I manually format one of the sheets and then simply apply that same Macros to all the relevant worksheets. The issue here is that the number of data entries (that is, rows/columns), may differ between worksheets. So if sheet 1 has 20 rows and sheet 2 has 40 rows, a significant amount of data will not be included in the formatting, since I recorded the Macro on sheet 1. The real question: How can bulk format several Excel worksheets/tables/workbooks uniformly, given that the number of data entries per [worksheet] may vary? Again, any help would be greatly appreciated. Thank you
Relative conditional formatting
Hello, I have multiple worksheets in Excel 365 that present data from one month to another. I am trying to make the data turn green if it's gone up since the previous month or red if it's gone down. I would like to know the quickest way to copy-paste the conditional formatting so it is relative to the previous month and not reference the original cell in the formula. ex: I have sales in column A2 to A50 in worksheet february and would like to format it n relation to column A2 to A50 in worksheet january while matching A2 feb with A2 jan, A3 feb with A3 jan... I hope I'm being clear. If it's easier with Icons, I can do that instead. Thanks!
Conditional Formatting values across tables
Hi, Could someone please assist me with this. I have attached a photo to add context. When I write values into the green table I would like the figures to become red if they are less then the corresponding cell in the yellow table. I know how to format each cells independently but is there a way to do it multiple times? It won't work if highlight multiple cells. Cheers, Chris
