| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of Multiple Cells
I would like to turn one cell several different colours according to the
contents of other adjacent cells. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting for multiple cells | Excel Worksheet Functions | |||
| multiple cells conditional formatting | Excel Discussion (Misc queries) | |||
| Copying Conditional Formatting to multiple cells | Excel Discussion (Misc queries) | |||
| conditional formatting to multiple cells | Excel Worksheet Functions | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Linear Mode
