| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thanks to Stephen, it works.
"Stephen" wrote: For conditionally formatting cell A1, use =OR(A1="A",A1="B",A1="C",A1="D",A1="E") "yclhk" wrote in message ... Thanks for all. I think the solution of using OR function is more simple. However, how to compose the formula in this formatting ? Thanks again for your help, "David Biddulph" wrote: If you do mean that you want one designated format if the cell value is A, B, C, D, or E, then you can use an OR function in your conditional formatting condition. Use Formula Is, not Cell Value Is. -- David Biddulph "yclhk" wrote in message ... How to include more than 3 conditions for formatting the cell ? For example: if the cell values are A, B, C, D or E, the cell displays in a designated format. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
