Hi
have a look at 'Format - Conditional Format' for this

--
Regards
Frank Kabel
Frankfurt, Germany


ig wrote:
greetings i want to know how to change the color of a cell if the
letter x esists in a range of cells........... ie


a b c d
pete x

so the word pete would be black if nothing was in a1:a1000 or in this
case it would need to be in red.