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.
Martin_Weiss Thank you for your help. However, I am not sure I fully understand your advice. How does one determine the "active cell"? I want the entire highlighted spreadsheet to be affected. Do you choose the upper left cell in the highlighted area for example?
Your advice sounds good - I just have a question regarding how you determine the active cell.
I am looking forward to hear your reply.
Art
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.
- So you peg the upper left cell and the lower right cell of the area to be highlighted. My spreadsheet is fairly large (A - R) and 1 - 120 rows. I will give that a try. Thanks alot!
- That made the color change for all numbers less than zero. Thanks very much for your help you mysterious techno-knight. 🙂