colour text

T

Tom McD

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.
 
B

Bob Phillips

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)
 
Top