| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour cell (or text) depending upon IF Function result
I have a personal finance sheet that calculates a simple balance (in
Cell F1). Next to the balance (in Cell G1) I have an IF function that inputs text depending on the current balance. It is as follows: =IF(F10,N9,N10) (where N9 = BALANCE OK and N10 = WARNING OVERDRAFT ENTERED) Is It possible to force excel to colour the cell depending upon the message that is displayed. i.e. if the balance is -100, then the message is WARNING OVERDRAFT ENTERED - I would like this to be displayed in red or have the coloured in red. If it displays BALANCE OK, I would like the text to be Blue (or the cell clour to be Blue). Can this be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get cell to automatically change colour depending on text in adja. | Excel Discussion (Misc queries) | |||
| Cell text and background colour dependant on result | Excel Worksheet Functions | |||
| Insert text depending on font colour | Excel Discussion (Misc queries) | |||
| How to insert line of text on other worksheet depending upon result in a cell? | Excel Discussion (Misc queries) | |||
| How do I change the color of a cell depending on the result of the function in that cell | Excel Programming | |||
Threaded Mode
