Forum Discussion
Coloring spreadsheed numbers automatically
Hi phoenix98604
the active cell is always the one sitting on the top left corner of your selection. In the following screenshot, the selected range is B3:D10, but the active cell is only B3.
So in the formula for the formatting rule, you would have to reference only B3 and it will apply dynamically to all other cells in the range B3:D10
I hope this makes it a bit clearer to you.
Number formats also allow colours to be set, with red commonly used for negative numbers. The format can be applied to entire sheets by selecting the marker to the top-left of the sheet. The problem is that you may also have counts or percentages on the same sheet which will need their own styles to be applied.
The image is of a custom number format based upon the UK accounting format.