ExcelBanter - Cell Pattern

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

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

- - Cell Pattern (https://www.excelbanter.com/excel-discussion-misc-queries/3484-cell-pattern.html)

Peter M

Cell Pattern

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

Norman Jones

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

Peter M

thanks Norman. this was very helpful

peter

"Norman Jones" wrote:

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

All times are GMT +1. The time now is 07:09 AM.