You may use this code (or a similar one better meeting your needs) to the cells generally or to any of the cell styles to overlay condtionally. To not display any content set the format code to "" "" "" "" where the 4 parts will apply to positive values, negative values, zero value, and string in this order. To make the numeric (or even string) values of the cells referable, and controlling the CF, but invisible, you need to set the appropriate format code under Format Cells. The ColourScale option is not appropriate for the purpose. To colour the cells regarding your chosen assignment is then the duty of the Conditional Format (CF) you have to define.īy regular CF you will need to define 9 dedicated cell styles and 9 conditions for overlaying them. The numbers must first be entered into the cells or returned by the formulae contained in the cells in any case.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |