Conditional Formatting of Multiple Cells

  • Thread starter Thread starter joesw
  • Start date Start date
J

joesw

I would like to turn one cell several different colours according to the
contents of other adjacent 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Question about conditional formatting of zeros in Excel 0
How can I set more than 3 conditions for cells? 2
conditionally formatting cells based on other cells 1
Excel Conditional Formatting Removal 7
how do i format a cell based on format of a range of cells? 2
Conditional Formatting - Excel 2003 2
Formatting in Excel 2

Back
Top