custom formatting

Hi Further to my previous question I was wondering if there was a way to add this [>=1000]#,###; to this custom format [<999950]0,"k";[<999950000]0,,"m";0.0,,,"b" so if the number is below 1000 it displays as is? Because I notice that the chart will only respond to the custom formatting not...

Hi, I am trying to format a cell with 2 types of formatting conditions that will display correctly on a chart. For instance if the cell is below 1000 I want it to use the standard number formatting, but if the cell is between 1000 -10000 I need it to look like 2.5k and for anything over 10000 I...

Hello all, I'd like to have a custom number format that has negative numbers starting with a -, and positive numbers starting with a +. Any Help would be greatly appreciated. Andrew

I have a sheet the pulls data from records to calculate the average length of time different actions we track take to happen. The problem is this sometimes results in nice neat numbers with no or only a few decimal places and sometimes results in irrational numbers showing 9 decimal places. I...

Hi! I am looking to format a range of numbers to only show a decimal when the decimal is .5. Ex- .5, 1.5, 2.5...etc. So if the number is 2.6, I'd like it to just round to 3 or if the number is 1.2, I'd like it to round down to 1, no decimal. I've never done custom formatting, so I am trying to...

Hey all, I am trying to format a cell so that if you type in the date (11/2) it will display "Monday - 2", or "Tuesday - 3" etc. Any help would be great!

Hi all, I was wondering whether it is possible to apply a color scale (red [low] - white - blue [high]) based on a nxn matrix to a different, distinct nxn matrix. If its not possible, can anyone think of a clever way to do this? Right now I am defining 10 distinct custom rules, which apply...

Hello, I have a large range of cells that I want to apply Conditional Formatting to as follows: If not blank & value is not between L6 and M6, then fill red. I would like to do this using a single format, perhaps using a custom formula? I will be putting it in VBA, but with a working...

Hi, I have a line chart with dates formatted as YYYY on the X-axis. For some years the data charted represent actual values while some years represent estimates, for which reason I would like to add an "e" following the YYYY format. So problem is: how to do a custom format which will put an "e"...