| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I do conditional formatting on number formats not patterns.
Cell A1 is a drop down list that you select either "A" or "P". Cell B1 is a
cell where the user enters a number. If A1 is "A" I want the number in B1 to show as an amount in $ whereas if A1 is "P" i want B1 to show as a percentage. The conditional formatting option allows me to change fonts, borders, and patterns but not the number format. Any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
| Conditional formatting row when cell value is an even number | Excel Worksheet Functions | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Threaded Mode
