ExcelBanter - How can i put text in a cell depending on colour

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can i put text in a cell depending on colour (https://www.excelbanter.com/excel-worksheet-functions/449945-how-can-i-put-text-cell-depending-colour.html)

Esradekan

How can i put text in a cell depending on colour

I have conditional formatting set up to determine the colour of a cell, what I need to do is to have that condition/colour to place some text in the cell. How can I do that? Can anyone help?

TIA
Esra

All times are GMT +1. The time now is 11:06 AM.