|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 13th 05, 05:43 PM
|
|||
|
|||
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 | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting - multiple condition | jenhow | Excel Discussion (Misc queries) | 5 | August 17th 05 02:45 PM |
| Conditional Formatting Error | ddate | Excel Worksheet Functions | 0 | May 5th 05 09:00 PM |
| difficulty with conditional formatting | Deb | Excel Discussion (Misc queries) | 0 | March 23rd 05 06:13 PM |
| Why won't my conditional formatting display in the cell | Cashius War eagle | Excel Discussion (Misc queries) | 3 | February 15th 05 08:38 PM |
| Conditional formatting not available in Excel | BAB | Excel Discussion (Misc queries) | 2 | January 1st 05 03:33 PM |
Threaded Mode