| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
I am trying to make a conditional formatting that is similar to the Conditional Formatting that is included in Excel. The only difference is that I need to have about 10 different conditions that I would like to test, and format.
The formatting is based on "Live Prices" in my worksheet that is updated continously. If the prices go below or above certain levels (Other predefined cells in the worksheet) I want the colour of the cells to change. The conditional Formatting in Excel would be perfect, but it is only 3 conditions to test, and I need about 10 different conditions to test. Anyone have any idea of how I could solve this problem? -- Peter B Norway |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![Peter B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
