Hi
I have spent ages searching for an answer and I suspect this may not be possible to achieve in excel, but here goes...
I have a group of cells that are conditionally formatted using a formula to apply one of three colours depending on which condition is met (NB, the cells don't contain any text or numbers). See attached sample file.
I would like to add some text to the conditionally formatted cells to display a dynamically updated text string.
Question 1
Is there anyway to achieve this in excel?
Question 2
Is there any way in excel to allow a number to run over into adjoining cells in the same way that text does if there is no entry in the adjoining cell?
I would be grateful for any help on this... as to if it is possible to achieve.
Many thanks.
Bookmarks