ExcelBanter - get cell to automatically change colour depending on text in adja.

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - get cell to automatically change colour depending on text in adja. (https://www.excelbanter.com/excel-discussion-misc-queries/248031-get-cell-automatically-change-colour-depending-text-adja.html)

wilko

get cell to automatically change colour depending on text in adja.

get cell to automatically change colour depending on text in adjacent cell,
can anyone help?

Gary''s Student

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?

Chaitanya_Sagar

get cell to automatically change colour depending on text in adja.

Good suggestion. You have a experiment a couple of ways before it works the
way you want it to.

Chaitanya
http://www.p2w2.com/chaitanya_sagar/index.php

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

All times are GMT +1. The time now is 06:00 PM.