ExcelBanter - Conditional Formatting of Multiple Cells

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

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

- - Conditional Formatting of Multiple Cells (https://www.excelbanter.com/excel-discussion-misc-queries/243775-conditional-formatting-multiple-cells.html)

joesw

Conditional Formatting of Multiple Cells

I would like to turn one cell several different colours according to the
contents of other adjacent cells.

Sean Timmons

Conditional Formatting of Multiple Cells

=AND(B2=4,C2=6,etc) and set your color for each condition.

Please keep in mind, if condition 1 is met, conditional formatting will NOT
review any other conditions.

"joesw" wrote:

I would like to turn one cell several different colours according to the
contents of other adjacent cells.

All times are GMT +1. The time now is 03:02 AM.