Hi Peter,

See Format | Conditional formatting.

Debra Dalgleish has an excellent tutorial on CF at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"Peter M" wrote in message
...
Is it possible to define a Pattern for a cell (i.e. cell shading)
depending
on a value or condition in another cell?
--
Thanks for any help