get cell to automatically change colour depending on text in adja.
Use Conditional Formatting with the Formula Is option.
--
Gary''s Student - gsnu200908
"wilko" wrote:
get cell to automatically change colour depending on text in adjacent cell,
can anyone help?
|