View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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.