| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting that will display conditional data
I would like to be able to enter a number into a cell and then have that
number automatically change to a different number. Example: I would like to be able to enter 1000 in cell A2 and then have $15.09 be visible instead. Is this possible? I have tried using =IF(A2<1500,15.09,"") in the Formula Is option of the Conditional Formatting option, however, it does not work. Please advice. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
