ExcelBanter - colour text

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - colour text (https://www.excelbanter.com/excel-programming/305287-colour-text.html)

tom mcd

colour text

HI all, I want to create a macro to change the colour of
cells which have the word failed in them. Can anyone
please help. Thanks.

Bob Phillips[_6_]

colour text

Use conditional formatting with a condition of equal failed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tom McD" wrote in message
...
HI all, I want to create a macro to change the colour of
cells which have the word failed in them. Can anyone
please help. Thanks.

All times are GMT +1. The time now is 08:05 AM.