Change cell text depending on colour of a cell

Hi all,

I have cell A6 which has a number between 1 and 10 and changes colour depending on the number value of that cell (using conditional formatting) (red if less than 3, orange if between 3 and 7 and green if more - I know there are numbers to these but I can't remember them!).

What I want to do is to have text in another cell (A9) and for the cell in that text to be dependant on what colour the cell A6 is.

So if cell A6 has a value of 2 and is therefore red, I would want cell A9 to have the text "Value below tolerance".

Any help appreciated (I searched for an answer but scenarios are different to mine and can't adapt them).

Many thanks.

Why can't you use the same conditions as your conditional formatting?

A9: =IF(A6<3,"Value below tolerance",IF(A6<8,"Value ...","Value ..."))

Regards

Do you know when you can't see the forest for the trees.....I feel rather daft now!

Thanks

Oh yes, been there, done that. Missed a job because, in the interview, I was trying to provide an aethetically pleasing and technically scaleable solution ... and they were looking for the simple (and obvious) answer. C'est la vie

Regards