| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 36998 | 2003-08-25 20:23:00 | Excel | nw3mrgc1 (3436) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 170498 | 2003-08-25 20:23:00 | I would like to know if it is possible to change the background colour or font of a cell after it has been changed/overwritten in Excel. | nw3mrgc1 (3436) | ||
| 170499 | 2003-08-25 21:15:00 | Probably not quite what you want, but you can use conditional formatting (Format > Conditional Formatting ) to apply font/background formats to a range of cells based on a test criteria. You can have several conditional formats in operation, so you could have e.g. the background change from green to yellow to red depending on cell values. :| | wuppo (41) | ||
| 170500 | 2003-08-25 21:17:00 | Select the cells you want to apply colour to. On the Format menu, click Cells, and then click the Patterns or Font tab. These will enable you to make the changes you want. These changes can be made regardless of the cells contents. |
Capt Jimbo (17) | ||
| 170501 | 2003-08-25 21:24:00 | If it's just changed cells you want to highlight, go to: Tools > Track Changes > Highlight changes. This won't change the colour of the background, but will change the colour of the box around the cell (as well as add a comment to the cell). You can then go back and accept/reject each change as you want it (there's another option in the Track Changes menu for accepting changes). HTH Mike. |
Mike (15) | ||
| 170502 | 2003-08-26 00:39:00 | Hi, you'll need to explain a bit more about what you are trying to achieve. For example, if the cell is changed twice then what happens? As others have said, conditional formatting & tracking changes would be a good option. If your goal is to prevent changes then protecting the sheet is the answer. Also you can have custom macro's that can do the above and much more such as colour the cell, add a comment etc. |
parry (27) | ||
| 170503 | 2003-08-26 10:41:00 | Hi, thanks a lot for the replies. I like the idea of conditional formatting - how would I do that? | nw3mrgc1 (3436) | ||
| 170504 | 2003-08-26 11:30:00 | Just go to Format - Conditional Format- Set the test conditions, and set the format you want to occur when those conditions are met. If all else fails, try Excel Help. |
godfather (25) | ||
| 1 | |||||