Add Text to a cell that has Conditional Formatting applied

[HangMan]

Hi

I have spent ages searching for an answer and I suspect this isn't possible to achieve in excel, but here goes...

I have a cell that applies conditional formatting via a formula (NB, the cell's conditional formatting isn't based on a text or numeric entry already in the cell). to apply one of three colours. I would like to also add some text to this cell that displays either text or a number derived from a calculation elsewhere on the worksheet.

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, many thanks.

 

[Special-K99]

Sounds fairly straightforward, can you supply a couple of examples of what you're trying to achieve?

 

[HangMan]

Hi Special-K99

How can I attach a sample file?

The xls add-in, currently says File Not Found.

Many thanks